Search results 51

Sorted from new to old.
Card image
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

Card image
ReplaceStrings

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

Card image
Range2Block

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

Card image
ANStr2Range

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

Card image
Range2ANStr

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

Card image
CreateUniqueList

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

Card image
ANStrSort2

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

Card image
CreateList_Matching

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

Card image
Column2AnString_Unique

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

Card image
ANSQLWherein

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

Card image
Files_MostRecentN

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

Card image
ApplyValidation_DropDown

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

Card image
FoldersIn5

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

Card image
ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

Card image
FoldersIn

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

Card image
Posts_per_Year

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