Скачать или смотреть Free Excel VBA Course #12 - Using Object Variables in Excel VBA

In this video, I will cover what object variables are and how to use these in VBA in Excel.

Just like you can store data in a data variable, you can store an object in an object variable. For example, you can create an object variable that always refers to a specific cell or range or worksheet or workbook.

The video will show you how using object variables in VBA can help build a lot of better codes.

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

-------------------------------------------------------------------------------------
00:00 Introduction to Object Variables
01:21 Data Variables Review
02:28 Object Variables Basics
04:52 Object Variable with Single Cell Example
06:07 Object Variable with Range of Cells
08:52 Using Dynamic Ranges with EndXL_Down
09:19 Working with Worksheet Variables
11:36 Adding New Worksheets with Variables
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial