Search results 51

Sorted from new to old.

MathInsideANString

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

2023Nov20

ReplaceStrings

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

2023Nov11

Range2Block

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

2023Mar6

ANStr2Range

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

2022Nov11

Range2ANStr

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

2022Jul19

CreateUniqueList

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

2022Apr26

ANStrSort2

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

2020Sep24

CreateList_Matching

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

2020May13

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

Files_MostRecentN

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

2018Oct1

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

ExportSheets_to_1PDF

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

2018Aug8

FoldersIn

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

2018Aug3

Posts_per_Year

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

2018Jul29

1 2 3 4