Similar codes
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
ANmaCopy_Objects
Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...
2020Nov11
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
Range22DimArray
Imports a range into 2-dimension array. Returns the array, providing range, ...
May11
Highlight row of current month
Highlight row in Excel if it is within current month This is another version ...
2021Sep2
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
CopyDynamicRangeValue
Copy values from range to cell. Without using clipboard of course. Here the ...
Aug10
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
Shape_Select_or_CreateThenSelect
Selects a shape inside sheet to change it, or if not found, it will create it ...
2022Jul21
JSPasswordStrength
Quick popup bootstrap 3 popover message to measure password strength ...
2020Sep3
Save to, Read from, Delete registry key
Save into registry, read from registry or delete a key. Accessible to only ...
2019Jun15
DirTree.xlsb
Excel macro to show all files found in directory (including sub-directories) as ...
2019May20