Search results 34

Card image cap
ANStr2Range

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

Card image cap
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

Card image cap
Range2ANStr

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

Card image cap
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

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
Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

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