How do I relegate the curser movement in a formula?
 

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?

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?

How do I relegate the curser movement in a formula?
 

Thank you Mr. Ogilvy - You made an "Old man smile again". This worked
perfectly!

"Tom Ogilvy" wrote:

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?