The Range Object in Excel VBA 2010

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Reddit

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

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Reddit