Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
Returns list of rows numbers having cells matching text in a column. Passing ...
2021Dec27
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
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 ...
Apr30
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
Minify and unminify tools online, mainly js and css, free Unminify js, css, ...
Jan27
Gets images in a folder where filenames start with "User" Similar to function ...
2019Dec31