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.
Vba Range Get Worksheet Worksheet : Resume Examples (Chris Collier)
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.
How to use a VLOOKUP function in Excel VBA
VBA Range Cells | How to Use Excel VBA Range Cells?
Excel Vba Copy Range Cells Another Worksheet – Rapael
Excel-VBA : Range - Lock/Unlock Specific Cells
VBA Set | Assign Reference to An Object,Cell Range Using ...
VBA UsedRange | How to Find the Number of used Rows & Columns?
vba - Unhide rows based on cell value - Stack Overflow
VBA-Excel: Add Worksheets For All The Given Dates Except ...
Sort Worksheet Ranges in Userform - Excel VBA - YouTube
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.