Similar codes
ShapeRange_BG
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
.jpg)
RoundMinutes
Rounds time into nearest quarter up or down, half up or down based on argument ...
2019Jan9
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
2023Dec23
Range2Block
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
MoveDown + MoveUp
Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
Recently by developer
HTMLTable_FindTable
Reads < table .... < /table> found after index Have ability to opnly bring the ...
Sun 1PM
ANStrFind_AndOrRemove
Checks (and/or removes) if an item was found in list of items and return 1 if ...
Sun 1PM
ANmaSearch_AllWords_FromANStr
Checks if string has all words from ANStr inside Retuns 0 if not found or ...
Jan8
Random Codes
SumOf_3Filters
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
RemoveCommaBetween2Quotes
Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)
2018Jul24
