Similar codes
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
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
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
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
ShapeName clicked
Simple command to know which object (shape) the user clicked When you assign a ...
2022Feb4
Modify volume using nircmd
Batch file to lower volume of computer system (using nircmd.exe).
2021Jan1
File2Body
Reads file and showing it as Bootstrap row, with ability to replace variables ...
2020Dec15
GetFilename, GetExtension, .. others
GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...
2018Jun11