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
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
SendEmailMsgv2023
Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...
Nov12
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
FixENTERS_File
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7