Range2ANStr

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

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

ANmaSQL_UpdateDateStatement

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

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

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

RowList_Matching

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

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...