EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

ANStrSort2

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

Column2AnString_Unique

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

ANSQLWherein

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

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

ApplyValidation_DropDown

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

FoldersIn5

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

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Resources.zip

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

ANStrRead + ANStrSave + ANStrSearch

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

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...