Search results 29

  2. Search results
  3. anstring
Card image cap
Range2ANStr

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

Tue Jul19 3AM
Card image cap
CreateUniqueList

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

Tue Apr26 12PM
Card image cap
ANStrSort2

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

2020Sep24
Card image cap
CreateList_Matching

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

2020May13
Card image cap
Column2AnString_Unique

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

2020May6
Card image cap
ANSQLWherein

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

2020Jan6
Card image cap
Files_MostRecentN

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

2018Oct1
Card image cap
ApplyValidation_DropDown

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

2018Aug10
Card image cap
FoldersIn5

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

2018Aug8
Card image cap
FoldersIn

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

2018Aug3
Card image cap
Posts_per_Year

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

2018Jul29
Card image cap
DB_SettingRead_Field

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

2018Jul24