Search results 45

Card image cap
ReplaceStrings

Replace strings found in list of strings from inside a string, does taht make ...

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

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 ...