Search results 82

Sorted from new to old.

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

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Range2ANStr

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

2022Jul19

DBTables

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

2022Apr28

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

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

1 2 3 ...5 6