| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the active cell
What piece of code will cause the curser to go to Column A of the active
row? So if the cell is in R21 when the code is run I want the cell to move to A22. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the active cell
cells(activecell.row,1).Select
-- Regards, Tom Ogilvy "Patrick Simonds" wrote in message ... What piece of code will cause the curser to go to Column A of the active row? So if the cell is in R21 when the code is run I want the cell to move to A22. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the active cell
Hi,
Believe Tom has just forgot +1 for the row ... Cells(ActiveCell.Row + 1, 1).Select Carim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the active cell
Thanks to all, but Toms tip worked fine.
"Carim" wrote in message ps.com... Hi, Believe Tom has just forgot +1 for the row ... Cells(ActiveCell.Row + 1, 1).Select Carim |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the active cell
right click sheet tabview codeinsert thismodify to suit
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Row 5 And Target.Column = 8 Then ActiveCell.Offset(1, -6).Select End Sub or in a regular sub activecell.offset(1,-20).select HOWEVER, it is rarely desirable to select so post your code for comments. -- Don Guillett SalesAid Software "Patrick Simonds" wrote in message ... What piece of code will cause the curser to go to Column A of the active row? So if the cell is in R21 when the code is run I want the cell to move to A22. |
| 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) | |||
| Changing an active cell format in VBA | Excel Discussion (Misc queries) | |||
| Changing the active workbook | Excel Programming | |||
| changing active cell | Excel Programming | |||
| Changing active cell to a color | Excel Programming | |||
Linear Mode
