Get our FREE VBA eBook of the 30 most useful Excel VBA macros.

Automate Excel so that you can save time and stop doing the jobs a trained monkey could do.

Claim your free eBook

Recent Blog Posts

How to add a drop-down list in Excel (3 easy ways)
How to display fractions in Excel (the easy way)
Combine rows in Power Query - featured image How to combine rows in Power Query
Excel Tables absolute references Excel Table absolute reference for cells, columns, and rows

Useful VBA codes for Excel (30 example macros + Free ebook)
Convert Color Codes - Featured image How to convert color codes (RGB, HSL, HSV, Hex, Long, CMYK)
Data Validation with Excel Tables How to use Excel Table within a data validation list (3 ways)
How to add double quotes in Excel formula

Public Vs Private Private vs Public Subs, Variables & Functions in VBA
VBA Code Snippets VBA protect and unprotect Sheets (25+ examples)
0040 Combine tables in PivotTable Featured Image How to create a PivotTable from multiple Tables (easy way)
VBA Code Snippets How to save Excel as PDF with VBA (10 examples)