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 |
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 |
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. |
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