Excel Developer Reference
Ranges Object
A collection of Range objects that represent worksheets in a workbook.
Remarks
Similar to the way bookmarks are used in a document, Range objects are used in Visual Basic procedures to identify specific portions of a workbook. Unlike a bookmark, however, a Range object exists only while the procedure that defined it is running.Range objects are independent of the selection. That is, you can define and manipulate a range without changing the selection. You can also define multiple ranges in a document, but there can be only one selection per pane.
Use the Range method to return a Range object defined by the given starting and ending character positions.
Use the Range property to return a Range object defined by the beginning and end of another object. The Range property applies to many objects.
© 2006 Microsoft Corporation. All rights reserved.