Similar codes
MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
LastRow_Remove
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
CopyRowHeight
Copy row height from row to another Used to fix row heights or merged cells to ...
2019Aug1
Range2Block
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
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
Nearby Color shades
Calculate colors close to input color, a jquery html that will give you 10 ...
Nov8
ANmaVLookup
Finds first occurrence of item in column, then returns value from same row as ...
2022Dec23
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
