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
.jpg)
RoundMinutes
Rounds time into nearest quarter up or down, half up or down based on argument ...
2019Jan9
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
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
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
Arr_1Dim_2Str
Converts 1-dimension array into text. Meet Join. A way to convert array into ...
Aug14
Limit Characters in a TextArea
This will limit the number of characters a user types in a textarea.
2018Apr18