Codes Required
Similar codes
AddressReferenceStyle
Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...
2023Nov1
ANmAddressRefStyle
Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...
Sep23
ANmAddress_Value
Returns the value of a cell address in another sheet. Todo: Allow to reference ...
Oct31
HTMLPadding_v2
Finds the padding or margin from a style statement for an HTML tag. Passing ...
2024Jan5
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Styles_DeleteNonStandard
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
Recently by developer
ANmaUploadFTP_Script + ANmaUploadFTP_1File
Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...
Sun 5AM
ANmaNotMatch
Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...
Apr19
FirstDuplicatedItem
Returns the value of first duplicated item found in a range. This is to ...
Apr18
ANmaRow_Duplicate1
Duplicate 1 row into row below with insert using fill down or copy-paste No ...
Apr17
Random Codes
Bootstrap 5 color toggle
Working toggle button to switch between light and dark color modes in Bootstrap ...
2023Aug6
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
RunFromTemp
Check if an Excel file is running from 'Temp' location or regular folder This ...
2018Jun17
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26