Codes Required
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
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
Between2int and Between2intinc
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
Just learnt that now
Looks like we cannot have filename (having no extension) and folder in same ...
Mar5
NumberNumberNumber
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
NameSilo_APICall_ListPrices
Downloads list of domains and prices for register, renew or transfer into ...
2018May25
DownloadFile
Download a file from URL from inside Excel into certain path, returns blank if ...
2018May22
FrmLarge v3
Shows an image after clicking on its thumbnail, like in web applications Can ...
2018May20
Calendar, a pure-VBA userform (FrmCal)
VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...
2018May16
Similar codes
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
DB_Setting2Read + DB_Setting2Save
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
LstCustomSelection_Refresh
Read list of items from Settings sheet, then Sort, then save, before reading ...
2022Aug31
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
SettingRead+SettingSave
This is the final version of my set of Setting functions SettingRead, ...
2018Apr27
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
SettingNameAlreadyFound
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
