View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim
 
Posts: n/a
Default 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