Similar codes
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
SumOf_3Filters
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
UserChanged_Log4
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
BrowserSetting
Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...
2022Apr29
