VBA - Selecting cell ranges

Post date: May 18, 2011 12:41:56 PM

Selecting a cell range is almost exactly the same as selecting a single cell. The only difference is that you use a colon to separate the beginning and ending cell references, like so:

Range("A1:B4").Select

'Selects cells A1, A2, A3, A4, B1, B2, B3, and B4.

Range("A:A").Select

'Selects the entire Column A

Range("A:C").Select

'Selects Columns A, B, and C

Range("1:1").Select

'Selects all of Row 1

Range("1:57").Select

'Selects Rows 1 through 57