Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...
2018Jun24
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
Resizes Excel window to certain small size and location (hard-coded) and hide ...
2020Dec11
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
How to fix error (User-defined Type) error, especially when using outside ...
2019Feb1
This will limit the number of characters a user types in a textarea.
2018Apr18