| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting a cell | Excel Discussion (Misc queries) | |||
| Excel 2007 single cell selecting muliple cell | Excel Worksheet Functions | |||
| Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
| Transfer cell values to another cell by selecting button. | Excel Worksheet Functions | |||
| Selecting a cell | Excel Programming | |||
Linear Mode
