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.

cells(activecell.row,1).Select

--
Regards,
Tom Ogilvy


"Patrick Simonds" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>

Hi,

Believe Tom has just forgot +1 for the row ...

Cells(ActiveCell.Row + 1, 1).Select


Carim

Thanks to all, but Toms tip worked fine.


"Carim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Believe Tom has just forgot +1 for the row ...
>
> Cells(ActiveCell.Row + 1, 1).Select
>
>
> Carim
>

right click sheet tab>view code>insert this>modify 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
(E-Mail Removed)
"Patrick Simonds" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>