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.