Selecting the first cell of a row

[Remko Campagne]

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]

cells(activeCell.Row,1).Select

 

[Beto]

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]

Cells(1, ActiveCell.Column).Select

Sorry, it was the other way around.

Cells(ActiveCell.Row, 1).Select