excel vba‎ > ‎

VBA - Selecting cell ranges

posted May 18, 2011, 5:41 AM by Roberto Felicini

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
Comments