LastRow_Remove

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

ANmaSQL_InsertStatement

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

ShapeName clicked

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

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

CSVs2Sheets

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

CSVs2Sheetsv0.2.xlsb.zip

Excel ribbon

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

Excel crashes when File > Print

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

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...