Codes Required
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
CutString_Words_Left + CutString_Words_Mid
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8
CutString1
Cuts a string from a string starting from a specific character index and until ...
2018Jul11
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
ANStringListRead_JSON
Reads array into list of ANString, from [ until ] for the giving array name. ...
Jan9
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
CalcArea
Calculates the area of objects. Pass formula argument as string and values as ...
2018Jul24
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
HTML_CleanNumber
Cleans block of string (HTML block) from characters that are not needed Can ...
Jan31
Filename_Clean
Returns cleaned file name of invalid characters. Needs to be modified if used ...
2023Jan11
Pure CSS Ribbon
Show a ribbon, in a simple CSS, Not my work, found it online, but it helped a ...
2018Dec8