Selecting the first cell of a row

Remko Campagne · Jan 5, 2004

Does someone know the macro for selecting the first cell
of a row when a cell in the same row is selected?

Thanks in advance,
Remko

Tom Ogilvy · Jan 5, 2004

cells(activeCell.Row,1).Select

Beto · Jan 5, 2004

Remko said:
Does someone know the macro for selecting the first cell
of a row when a cell in the same row is selected?

Thanks in advance,
Remko

Cells(1, ActiveCell.Column).Select

Regards,

Beto · Jan 5, 2004

Beto said:
Cells(1, ActiveCell.Column).Select

Sorry, it was the other way around.

Cells(ActiveCell.Row, 1).Select