Is there a go to function in excell
Hi,
Only with an event macro stored in the worksheet module ...
Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Range("C11")
If Target.Value = "x" Then '<<<< change cell
Application.Goto Range("D11")
End Sub
HTH
Cheers
Carim
|