How do I relegate the curser movement in a formula?
Right click on the sheet tab and select view code.
Paste in code like this:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$K$73" Then
Range("N1").Select
End If
End Sub
--
Regards,
Tom Ogilvy
"Jeff D." <Jeff wrote in message
...
I need to move the curser automatically in an excel spreadsheet to a
specified address on the work sheet; say from $K$73 to $N$1. Is there any
way
to do this in a formula?
|