Excel VBA Worksheets Object
We mentioned above that Range is a property. But what is it a property of? Well, Range is a property of the Worksheets object. If we wanted to be really specific we should have used the Worksheets object first, then the Range property. Like this:
Here, the Worksheet comes first. In between round brackets and quote marks you type the name of a worksheet, “Sheet1” in this case. You can also type a number between the round brackets:
The 1 above refers to the first worksheet in your open spreadsheet.
When you use Range by itself, Excel takes it mean the currently active worksheet, the one you currently have selected and displayed. If you want to refer to a different worksheet, say Sheet 2, you need to refer to it by name: