Codes Required
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
AddressReferenceStyle
Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...
Nov1
Excel 2010 hyperlink issue fix
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
ANmaHTMLPadding
Finds the padding or margin from a style statement for an HTML tag. Passing ...
Jan5
ConcatenateStrings_AmongString
Collect strings matching search from a longer string. I used it to concatenate ...
Jan17
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
OST Outlook file location
Outlook OST (and PST) files to be saved in different location Instruction can ...
2022May12
Checks if URL is valid
Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...
2018Dec9