AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

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

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

Export2CSV

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

CreateUniqueList

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

ShapeName clicked

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

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

RowList_Matching

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

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip