Search results 37

Sorted from new to old.

EnvironList

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

2021Jan12

ANStrSort2

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

2020Sep24

Column2AnString_Unique

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

2020May6

ANSQLWherein

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

2020Jan6

Rows 2 Cell

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

2019Jul30

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

RandomRecords

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

2018Jul29

CreateZipFiles_7Zip

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

2018Jul14

ConvertMultiLine2 + 6

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

2018Jul11

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

ListBox_SelectedIndexes

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

2018Jun11

Frequency

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

2018Jun8

DB_Setting1List + DB_Setting1List_NameValue

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

2018May31

FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

1 2 3