Search results 14

Card image cap
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Card image cap
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Card image cap
ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Card image cap
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image cap
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

Card image cap
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

Card image cap
GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Card image cap
Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

Card image cap
Most recent in Oracle DB

List the most recently added rows based on a date column.

Card image cap
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

Card image cap
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...