Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Counts how many cells matching 2 criterias.
Just like
May1
Creates list of unique items found in a column, returns string with items ...
2020May6
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Adds or remove zeros at start of string Used to clear heading zeros from ...
2019May31
Checks to see if a number is a primary number. Prime numbers are commonly found ...
2018Jul25
To raise a friendly error message with option to show custom error number and ...
2018Jul7