code Macro bank

Data Tools Excel Macros

Reusable, well-commented VBA macros. No VBA? In ExcelBot you ask the AI for the same thing in plain language.

All Data Tools 5 Automation 5
Macro Remove Duplicate Rows
Data Tools

Remove Duplicate Rows

Strip duplicate rows from a selected range in one click.

download bas 1 KB
Macro Auto-Format & Clean Sheet
Data Tools

Auto-Format & Clean Sheet

Bold the header, trim text and autofit every column.

download bas 1 KB
Macro Number to Words (SpellNumber)
Data Tools

Number to Words (SpellNumber)

Custom function to spell a number in English words — great for invoices.

download bas 1 KB
Macro Delete Blank Rows
Data Tools

Delete Blank Rows

Remove every empty row from the active sheet.

download bas 1 KB
Macro Freeze Headers on All Sheets
Data Tools

Freeze Headers on All Sheets

Freeze the top row on every worksheet at once.

download bas 1 KB