Similar codes
merge2Arrays
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
ANStr2Range
Converts a string of items into range, with custom separator.
Opposite of
2022Nov11
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Range_Add_or_Subtract
Adds an amount (or subtract) from a range of cells in one click
Similar to
2023Feb18
Range2Block
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
DeleteAllFiles
Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime
2018Jun30
