VBA automation for finance & Excel pros

Excel automation, documented properly.

Practical VBA macros and step-by-step guides for accountants, auditors and writers. Copy, paste and reclaim hours of manual work.

Browse posts Get started

0

Guides

0+

Ready macros

0%

Forever free

RenameSheets.bas

' Rename sheets from a list
Sub M31_RenameSheets()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Sheets
        ws.Name = "Cleaned"& ws.Index
    Next ws
    MsgBox "Done in seconds!"
End Sub

ExcelVBA MacrosPower QueryTally ExtractsAuditingFinanceAutomationData CleanupExcelVBA MacrosPower QueryTally ExtractsAuditingFinanceAutomationData Cleanup

Why BlogCell.Docs

Automation that respects your time

Built from real workflows, documented so anyone can follow along.

Copy-paste ready

Every macro is tested and ready to drop straight into your VBA editor. No setup gymnastics.

Real audit use-cases

Written from actual articleship and audit workflows — not toy examples.

Step-by-step guides

Clear explanations with the why, not just the code.

Free & open

No paywalls, no sign-up. Just useful automation.

Latest posts

Fresh guides and macros from the workbook.

VBA Code - Stratified Table

Generate a frequency analysis table from a column of amounts using Excel VBA.

VBA & PQ - Merge All Excel Sheets

Learn how to merge and combine multiple Excel sheets into one using a powerful VBA macro and Power Query.

VBA Code - Combine Multiple Excel Files

Learn how to merge multiple Excel files into a single workbook using a VBA macro. Save time and effort with this automated solution.

Start automating today

Dive into the guides and turn repetitive Excel work into a one-click macro.

Explore the guides