microsoft excel training class - What does Range("A1") mean

Hi Tom

Within relative reference code

ActiveCell.Offset(1, 0) - moves the active cell down 1 row and across 0 columns from the active cell.

Range("A1").Select - this specifies the range of cells to select. In other words, just select one cell.


If you wanted to select a range of cells 2x2 starting one cell below the currently active cell, you would use this code.

ActiveCell.Offsett(1, 0).Range("A1:B2").Select

This holds true for RELATIVE REFERENCE code.