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
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
SettingRead_JSON
Reads certain value for a certain setting from FullJSONString text block. See ...
2024Jan8
HTML2Str
Special version to convert HTML to string. Uses RemoveHTML, then after that it ...
2023Nov5
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
