Search results 78

Sorted from new to old.

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

ImagesIn_User

Gets images in a folder where filenames start with "User" Similar to function ...

2019Dec31

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

1 2 3 4 5