Similar codes
Paragraph2Line + Line2Paragraph
Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...
2018Jun2
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
SwapNumbers
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
ConvertMultiLine2 + 6
Convert text blocks (by converting line separators from any separator to any). ...
2018Jul11
ANStr2Range
Converts a string of items into range, with custom separator.
Opposite of
2022Nov11
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
Dropdown button commands
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...
2022Oct12
InStr and InStrRev
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
