Macros that verify your numbers. Catch errors before your reviewer does.
Scans every sheet for Ctrl+Shift+Enter array formulas — the invisible killers that block editing and hide from formula view. Zero input, one report.
Scans every column for formula cells whose R1C1 pattern doesn't match the column's dominant formula. Flags the one cell that was manually altered, copy-pasted wrong, or broken during a restructure — and writes a clickable report. Does not modify the original data.
Pick a template sheet, then this macro compares every other sheet's header row against it and flags missing, extra, or reordered columns on a clickable report. Find the one entity tab that breaks your consolidation before it breaks your formulas.
Scans every hyperlink on every sheet and tests file-path links for existence. Produces a report showing which links are live, which are broken, and which are web or email links that need manual review.
Scans every sheet module in your VBA project and lists all event handlers — Change, Activate, SelectionChange, and more — in a single report sheet so you can find the code that's silently reformatting, recalculating, or hiding your data.
Scans every sheet for volatile functions — INDIRECT, OFFSET, TODAY, RAND, and friends — and compiles them into a sortable report with an estimated recalculation cost. Find every drag on your workbook in 3 seconds.
Catalogs every pivot cache in the workbook — what data each one pulls from, how many pivots use it, and whether it's orphaned or a duplicate. Removes dead caches with one click.
Produces a one-page diagnostic report covering file size, sheet count, used-range dimensions, named ranges, pivot caches, custom styles, external links, hyperlinks, conditional formatting rules, comments, shapes, and VBA modules. The first thing you run when you inherit a mystery workbook.
Select any range with your mouse and get an instant MsgBox report: total cells, numeric count/sum/average, blanks, text, formulas, and errors. Faster than writing COUNT, SUM, COUNTA, and COUNTBLANK formulas you'll delete five minutes later.
Scans every sheet and reports protection status, password presence, editable ranges, and cell lock state on a single read-only report. The companion to Sheet Lock/Unlock — know what you're dealing with before you act.
Scans a workpaper for cells where the displayed value and the underlying value don't match — formatted to zero decimals but hiding fractional amounts. One click generates a ranked discrepancy report without touching the original data.
Scans all sheets (or just the active one) and compiles every formula into a searchable, hyperlinked report. Your original workpaper stays completely untouched.
One click converts every text-formatted number in your workbook to actual numeric values — no more SUMIF returning zero on your ERP trial balance export.
Select your header row, specify which columns must be populated, and this macro finds every blank and lists them on a clickable report. Never miss a missing account code again.
Color-codes every cell on the active sheet (or all sheets) by its type — formulas are blue, hard-coded numbers are yellow, text is green. Instantly see what's calculated and what's typed, without clicking a single cell.
Finds every IFERROR and IFNA formula on every sheet, classifies them as safe or suspicious, and flags the ones that are silently hiding #REF! errors behind a blank cell. Your workpaper looks clean — the macro proves otherwise.
Scans every sheet in a workbook, finds every formula error cell, and builds a clickable report with hyperlinks back to each one. Zero input — open a broken workbook, run the macro, and triage every error in seconds.
Scans every named range in your workbook, identifies which ones are broken (#REF!), lists them with visibility info, and deletes them all with one confirmation click. No more deleting them one at a time in Name Manager.
Select a column, and this macro flags every row where the value appears more than once. Light yellow highlight, zero deletions — you decide what stays and what goes.
Scans a workpaper for hard-coded numbers hiding in columns where every other cell is a formula. Flags only the suspicious ones — not every constant on the sheet — and writes a reviewable report to a new tab without touching the original data.
Paste your prior-year and current-year trial balances into two sheets, run the macro, and get a side-by-side comparison with dollar and percentage variances. Accounts that opened, closed, or moved more than your materiality threshold are all flagged in one pass.