Similar codes
CellHyperlink_ToSheet
Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...
2018Jun24
CellSave_Hyperlink
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
Excel 2010 hyperlink issue fix
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
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
Lazy image loading + placeholder
Setup lazy image loading plus setting placeholder to images.
Using
Feb10
User-Defined Formatting
Apply special Conditional Formatting, color cells based on their values. This ...
2019Jan9
Sheets to PDF pages
Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...
2018Aug8
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator
2018Apr23