Unlock Excel VBA & Macros Course is here!

Now available on Udemy!

Save time. Achieve more. Over 50 Excel macro examples for download & useful VBA codes you can use for your work.

Redeem your coupon for 75% off below.

Get 75% off the course
Free Ebook

Latest Tutorials

  • VBA to move data from one excel sheet to another

Excel VBA to Copy Data from one Sheet to Another

Can the Macro Recorder dynamically find the end of a range? This is where relative and absolute macro recording come into play. Each one has their advantages and disadvantages. In this tutorial I show

  • Complex dependent Excel drop down list

Find Multiple Matches in Excel & Create a Dependent Drop Down List

The aim of this tutorial is to create a dependent drop-down list that's based on a messy Excel Table. What do I mean by an unsorted Excel table? The categories for the first drop-down

  • Excel advanced filter a quick guide

Excel Filter: Basic to Advanced

Filter Basics First Excel's AutoFilter is a great feature to quickly display the rows in your data table that meet a certain criteria. The remaining rows that don't match your criteria are automatically hidden.

  • Copy Excel Formula without changing cell references

Copy Excel Formulas Without Changing Cell References

Would you like to copy your Excel formulas from one place to another without the cell references changing? Excel default behavior is to adjust the cell references when you copy a cell and paste

  • Excel VBA & Excel Macros and WordArt in Excel

Excel VBA: Control WordArt Fill with Macros

How can you get this effect? Find out how you can use Excel Macros to control the fill color of Word Art in VBA. In this specific case we have a dynamic Word Art

Trusted by