Automatically selecting a cell

[LINDSAYROSE]

Hi,
I need some help.
When cell R1 is selected i need the cursor to automatically go to cell D2 and so on (R2 to D3 )

the easier the better.

Thanks
Lindsay

 

[chicagodiceman]

As long as the offset is always the same, and the only time you want this to work is when the selected cell is in row "R" then place this code in the sheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 18 Then
ActiveCell.Offset(1, -14).Select
End If
End Sub

If this isn't what you're looking for, please post again.