The Range Object in Excel VBA 2010

Range is one of the most important and most commonly used Excel VBA 2010 object. The Range object contains two arguments that specifies a selected area on the spreadsheet. The syntax is Range(starting_cell,Ending_ Cell). 

For example, Range(“A1:C6″) means the specified range is from cell A1 to C6.

To select the specified range, the syntax is

Range(“A1:C6″).Select

where select is a method of the Range object

Learn more about the Range Object