Complete Guide to Range Information Properties - Excel VBA

Ranges are incredibly useful in Excel VBA because most data and useful functionality of Excel occurs in the cells. With a strong understanding of the Range Object in Excel VBA we can begin to design Macros that will greatly enhance our workbooks and automate tasks.

For shorter sections extracted from this video and more resources on the Range(Object) please see the Range(Object) - Excel VBA playlist here:
   • Range(Object) - Excel VBA  

00:00 Introduction
00:24 Create Range Object by Address (Single Cell)
00:57 Get Address of a Cell
01:30 Run-time Error 91 - Object variable not set
02:13 Get Column and Row Index
03:38 Range.HasFormula()
05:55 Create Range Object by Address (Multiple Cells)
06:52 Get Total Cell Count of Range
07:31 For Each Cell in Range (by Row)
09:23 For Each Cell in Range (by Column)


More Excel VBA tutorials here:
   • Getting Started with Excel VBA  

Engineering Statistics Videos here:
   • Engineering Statistics  

For support or inquiries please contact our support line: [email protected]

Excel Range(Object) Documentation: https://learn.microsoft.com/en-us/off...)