code Macro bank

Free Excel Macros (VBA)

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

star Featured

Macro Remove Duplicate Rows
Data Tools

Remove Duplicate Rows

Strip duplicate rows from a selected range in one click.

download bas 1 KB
Macro Combine All Sheets
Automation

Combine All Sheets

Merge every worksheet into one master sheet.

download bas 1 KB
Macro Export Sheet to PDF
Automation

Export Sheet to PDF

Save the active sheet as a PDF next to your workbook.

download bas 1 KB
Macro Remove Duplicate Rows
Data Tools

Remove Duplicate Rows

Strip duplicate rows from a selected range in one click.

download bas 1 KB
Macro Combine All Sheets
Automation

Combine All Sheets

Merge every worksheet into one master sheet.

download bas 1 KB
Macro Export Sheet to PDF
Automation

Export Sheet to PDF

Save the active sheet as a PDF next to your workbook.

download bas 1 KB
Macro Email Workbook via Outlook
Automation

Email Workbook via Outlook

Attach the current workbook to a new Outlook email.

download bas 1 KB
Macro Loop Through Files in a Folder
Automation

Loop Through Files in a Folder

Open every Excel file in a folder and process it.

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
Macro Create a Table of Contents
Automation

Create a Table of Contents

Build a TOC sheet linking to every worksheet.

download bas 1 KB