ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting the first cell of a row (https://www.excelbanter.com/excel-programming/286849-selecting-first-cell-row.html)

Remko Campagne

Selecting the first cell of a row
 
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

Selecting the first cell of a row
 
cells(activeCell.Row,1).Select

--
Regards,
Tom Ogilvy

"Remko Campagne" wrote in message
...
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




Beto[_3_]

Selecting the first cell of a row
 
Remko Campagne wrote:
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
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.


Beto[_3_]

Selecting the first cell of a row
 
Beto wrote:

Remko Campagne wrote:

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


Sorry, it was the other way around.

Cells(ActiveCell.Row, 1).Select

--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.



All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com