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.
✅ Download File: bit.ly/vbacourse-12
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial

[@RakshitChheda]

Useful in 2024. Thank you for amazing explanation!

[@jennydrumm7223]

Wow, this is a great video! Very clear and understandable information on things I've been struggling to understand. Thank you!

[@inderr7bajaj]

Bhai you have done a wonderful job... Great work... You have taught it in a very simple way which made a lot of sense... I have seen a lot of videos and google articles but none have explained it as simple and beautiful as you... Thanks a ton... Make a course on advanced VBA... And make it a paid one... People who have done this course would surely be interested in that one... It's really fascinating that you have provided such knowledge for free...

[@Melki]

Thank you, very good and clear presentation :)

[@JATINKUMAR-qu4vi]

Thank u so much for this wonderful and useful video.now my doubts are clear 🙏🙏

[@lilyfullery4779]

it was the best tutorial for vba

[@trumpexcel]

Glad you found it useful! :)

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@abhinaygarg7029]

Thank you

[@mono65]

Thanks a lot Sumit for this useful code. What about images? are they also treated as objects ?

[@pavankalyan6013]

Hi bro, How to store the lastusedrow in a variable and when we run the loop from lastusedrow value to some x value....
Pls help me to solve

[@leansixsigmaonlinetraining6138]

Hello Sumit Can you help on Error - Run Time Error 1004 - Unable to get AverageIF Property of WorkSheetFucntion class

[@kanchanthapa4255]

How vba learnt what we are refering to mycell

[@sunitas4575]

Mycell referring to the cell which you have chosen or declare. In the above training, A1 is mycell i.e. A is a column and 1is row.