2 Critical Excel VBA Assumptions You Must Know
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.
Видео 2 Critical Excel VBA Assumptions You Must Know канала Excel Campus - Jon
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.
Видео 2 Critical Excel VBA Assumptions You Must Know канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel Challenge: Equal Playing Time For Everyone!](https://i.ytimg.com/vi/EP-4UhiUjIc/default.jpg)
![Budget Template - Excel Template for Budget Spreadsheets](https://i.ytimg.com/vi/rvuNpABO6gw/default.jpg)
![Preview of PowerQuery, Pivot Tables, and Dashboards Video Series](https://i.ytimg.com/vi/WYfIgthJjFE/default.jpg)
![Excel Vlookup Assistant - Watch A Preview Of How It Works!](https://i.ytimg.com/vi/g2_Yu_VRQ9E/default.jpg)
![-free Webinar On Excel Dashboards! Quick Tip For Aligning Your Charts In Excel](https://i.ytimg.com/vi/_41lc3vsqSM/default.jpg)
![Excel 2007 Color Palette Conversion Tutorial](https://i.ytimg.com/vi/MXU0JewjhX4/default.jpg)
![Best Excel Tutorials For 2022: Top Excel Tips](https://i.ytimg.com/vi/tBixLkPplbQ/default.jpg)
![Excel Campus Vba Pro Course Tour - Get A Sneak Peek At Our Top-rated Course!](https://i.ytimg.com/vi/xoRsm5j6as4/default.jpg)
![Quick And Easy Tip For Navigating Formula References With The Go To Window](https://i.ytimg.com/vi/7-NwHtNl1YQ/default.jpg)
![How to Unpivot Data with Power Query in Excel](https://i.ytimg.com/vi/Kbu5RkUo6-k/default.jpg)
![Get Your Hero Tools Add-in For Excel Today!](https://i.ytimg.com/vi/FE6IU70RINM/default.jpg)
![Excel Mastery Unleashed: The Ultimate Cell Navigation and Selection Shortcuts](https://i.ytimg.com/vi/N9_I16nBUkw/default.jpg)
![New Excel Keyboard Shortcuts List + PDF Download](https://i.ytimg.com/vi/XtCK7_T9U8Y/default.jpg)
![Best Screen Sharing Tips For Virtual Meetings](https://i.ytimg.com/vi/tVTREe7vux0/default.jpg)
![How To Use The Screentip Function In Excel To Get More Out Of Your Data!](https://i.ytimg.com/vi/9GwpgMX_rec/default.jpg)
![Date Functions in Excel - Excel Is My Love Language 💖](https://i.ytimg.com/vi/J-lDQr3Ccr0/default.jpg)
![The Best Way To Split Text In Excel](https://i.ytimg.com/vi/yroWnF3bTd8/default.jpg)
![SORT & SORTBY Functions Dashboard Part 4 of 6](https://i.ytimg.com/vi/Li9awp2Hye8/default.jpg)
![10 Essential Shortcuts for Excel Tables](https://i.ytimg.com/vi/iCQfsUSF-_A/default.jpg)
![If Vs Vlookup Vs Xlookup - Which One Is Best For Commission?](https://i.ytimg.com/vi/iK_0ctO2PqI/default.jpg)
![Quickly Remove Indents In Ms Excel!](https://i.ytimg.com/vi/G8uLMhZSyBs/default.jpg)