Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Range2ANStr

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

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

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

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

Hide SQL table

A simple easy way to hide tables in SQL Server

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

GetGroupMembers

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

GetGroupMembers.zip

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

RowList_Matching

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