Similar codes
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
CellHyperlink_ToSheet
Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...
2018Jun24
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
Excel 2010 hyperlink issue fix
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
TeeOpen_ProtectTee + TeeOpen_UnprotectTee
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
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
Random Codes
HTMLTag + HTMLPair
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
InsertHyperlinks + GetHref
Converts https found in text into anchers < a > Comes with GetHref as bonus ...
2018May13