Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain two critical assumptions that VBA makes when running our Excel macros. Knowing these assumptions will help prevents errors and possible disaster when creating macros for Excel.

I explain more about these assumptions and other tips for getting started with VBA in my FREE webinar on "The 7 Steps to Getting Started with Macros & VBA".

https://www.excelcampus.com/yt-vba-webinar

This is an hour long in-depth training on getting started with macros. Even if you have been using VBA for awhile, you will probably learn a lot from this training. The webinar is going on right now, so click the link to register for a day & time that works for you.

https://www.excelcampus.com/yt-vba-webinar

The assumptions I'm referring to are all about Context. We must tell VBA what workbook and worksheet we want to run our code on. Otherwise, VBA assumes we want to run it on the active workbook and active worksheet.

This assumption can get us in trouble if the macro runs on the wrong workbook or worksheet. So it's critical that we know how to write macros with this assumption in mind.