Worksheet Excel Vba Range. If you wanted to access that array you could loop it and see if that value exists. Just like any object in VBA, worksheets have different properties and methods associated with it that you can use while automating your work with VBA in Excel.
This VBA tutorial provides a basic explanation of how to work with cells using Visual Basic for Applications. The following VBA guide is intended to show you have your can target specific worksheets within your workbooks in order to apply changes to them. Apart from cells and ranges, working with worksheets is another area you should know about to use VBA efficiently in Excel.
Have questions or feedback about Office VBA or this documentation?
A range is nothing but a cell or series of cells.
When you look around in an Excel workbook, you will find that everything works around cells. I made the change @scottcraner pointed out, the way I had it would error out if it did not exist. The Excel Range is also a Worksheet property.