Hello Sleah,

Your understanding of Offset is fine. It's the peculiar and undocumented action of the End property. End examines the starting cell to determine where the End of the selection is. If the start cell is non Blank it will search the range until it finds the last non Blank cell. If End starts with a Blank cell it will search until it finds the last Blank cell.

To solve your problem start searching your Column from the bottom up. The likelihood of the last cell not being a blank is remote.

Solution:

C = ActiveCell.Column
R = ActiveSheet.Rows.Count
ActiveSheet.Cells(R, C).End(xlUp).Select
ActiveCell.Offset(0, 1).Activate

Sincerely,
Leith Ross