SettingNameAlreadyFound

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

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

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

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

Frm56Msg.zip

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

Frm5Textbox

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

Frm5.zip