FoundinList

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

Range2ANStr

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

DBTables

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

Frm5Textbox

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

Frm5.zip

CopyFiles

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

RowList_Matching

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

Subtotal_Indirects

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

Frm6 - ANmaMultiSelect

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

Frm6.zip

EnvironList

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

ANStrSort2

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

CreateList_Matching

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

Column2AnString_Unique

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