VBA - Excel Ranges and Cells
This is a bit of "advanced" VBA tutorial for Excel "Ranges" and "Cells".
These properties are both simple and complicated in Excel. The point is, that there are 4 of them, depending on the object these are properties of.
Worksheet.Range
Worksheet.Cells
Range.Range
Range.Cells
Contents:
Range Object - 00:25
Just a small test - 01:09
Make sure to declare worksheets - 03:01
Worksheet.Range Property - 07:05
Worksheet.Cells Property - 11:49
Range.Range Property - 18:03
Range.Cells Property - 19:45
Based on the articles:
https://www.vitoshacademy.com/vba-cel...
https://vitoshacademy.com/vba-cells-a...
Docs.Microsoft.com:
https://docs.microsoft.com/en-us/offi...)
