Search results 29

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

Card image cap
ANStrSort2

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

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image cap
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Card image cap
ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

Card image cap
Files_MostRecentN

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

Card image cap
ApplyValidation_DropDown

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

Card image cap
FoldersIn5

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

Card image cap
FoldersIn

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

Card image cap
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

Card image cap
DB_SettingRead_Field

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