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
Random Codes
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
Blurred Background
Pure CSS trick to show a blurred background area behind a div Not my work, ...
2019Jun15
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
