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
where select is a method of the Range object