Search results 61

  2. Search results
  3. list commands
Sorted from new to old.
Card image
FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9
Card image
Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30
Card image
FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25
Card image
ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24
Card image
RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10
Card image
ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21
Card image
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1
Card image
SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23
Card image
FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9
Card image
ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9
Card image
Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27
Card image
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19
Card image
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15
Card image
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11
Card image
File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27
Card image
MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3
1234