View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?