5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
Five ways to find the last used row in Excel VBA — End(xlUp), UsedRange, Find, CurrentRegion and ListObject — with the traps each one…
Read article →Category Archives: Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Step-by-step: enable SAP GUI Scripting, record a transaction, and run it from Excel VBA to export a report automatically.
Read article →Send Emails from Excel with VBA and Outlook (With Attachments)
Send Emails from Excel with VBA and Outlook (With Attachments)
A tested Excel VBA macro that sends personalised Outlook emails from a list — with attachments, CC, a preview mode and a log column.
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →VBA String Functions: Left, Mid, InStr, Replace, Split and More
VBA String Functions: Left, Mid, InStr, Replace, Split and More
Clean and reshape text in Excel VBA with Left, Right, Mid, Len, InStr, Replace, Trim, UCase, Split and Join — with real data-cleaning examples.
Read article →VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
Handle errors in Excel VBA properly with On Error GoTo, find bugs with breakpoints, Watch and the Immediate window, and write comments that help.
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Learn every Excel VBA loop — For…Next, For Each, Do While, Do Until — when to use each, how to exit early, and how…
Read article →5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
Five small, useful Excel VBA macros explained: the Mod operator, finding the second highest value, summing by cell colour, deleting blank rows and highlighting…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Make Excel macros decide: If…Then…ElseIf, logical operators And/Or/Not, and Select Case — with real examples and common mistakes.
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Excel cells from VBA: fonts, fill colours, borders, number and date formats, alignment and conditional formatting — with copy-paste examples.
Read article →Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Everything you need to read and write cells in Excel VBA: Range vs Cells, Offset, Resize, CurrentRegion, rows and columns — with practical examples.
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Learn how to declare variables in Excel VBA, choose the right data type, use Option Explicit, and avoid the mistakes that cause type mismatch…
Read article →