| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select first cell in active row?
Good day all. Excel 2007
Can anyone assist with code to select the first cell in whichever row the currently active cell is to be found? If I record "Home" the macro given refers only to that specific cell, I need a dynamic result dependent an currently active row in the sheet. Thanks in advance for your always valued contributions. Wes |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select first cell in active row?
Try this line of code...
Cells(ActiveCell.Row, 1).Select -- Rick (MVP - Excel) "Wes_A" wrote in message ... Good day all. Excel 2007 Can anyone assist with code to select the first cell in whichever row the currently active cell is to be found? If I record "Home" the macro given refers only to that specific cell, I need a dynamic result dependent an currently active row in the sheet. Thanks in advance for your always valued contributions. Wes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Select specific cells in same row as active cell | Excel Programming | |||
| Select specific cells in same row as active cell | Excel Programming | |||
| how to select row according active cell? | Excel Programming | |||
| Select Row of Active Cell | Excel Programming | |||
![Wes_A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
