Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Creates list of items found in rows, where these rows match a value in another ...
2020May13
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
Saves value to cell without deformation and converting Used to be called ...
2018Jun26
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Reads array into list of ANString, from [ until ] for the giving array name. ...
Jan9
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18