Search results 23

Sorted from new to old.
Card image
ANStrSort3

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

Card image
ANStrFind_AndOrAdd

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

Card image
ANStrSort2

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

Card image
Files_MostRecentN

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

Card image
ApplyValidation_DropDown

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

Card image
FoldersIn5

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

Card image
FoldersIn

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

Card image
DB_SettingRead_Field

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

Card image
ExcelMenu_onfly

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

Card image
WordsOf + Words_Len

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

Card image
ANStrRead + ANStrSave + ANStrSearch

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

Card image
Frequency

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

Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

Card image
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

Card image
ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

Card image
CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...