Search results 27

Sorted from new to old.

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

Jun14

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

May25

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

ANStrFind_AndOrAdd

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

2023Dec19

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

1 2