ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns. Will work in sheet, ...

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

FoundinList

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

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

DBTables

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

CreateUniqueList

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

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

CopyFiles

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

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

GetGroupMembers.zip

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 ...

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...