EXCEL FUNCTION

[STAN BELBACK]

I WANT TO CLICK ON A CELL AND AUTOMATICALLY TO A LOCATION
ON THE SAME OR A DIFFERENT WORKSHEET. HOW CAN I DO THIS.
FOR EXAMPLE, I CLICK ON CELL F4 IN SPREADSHEET 1 AND I
AUTOMATICALLY GO TO CELL Z10 IN SPREADSHEET 3.

 

[Don Guillett]

It is considered rude to shout by typing in all caps. Please don't.
use a worksheet change event.
Right click on the sheet tab>view code>insert this>save.
When you CHANGE f4 you will goto sheet3

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$4" Then Application.Goto Sheet3.Range("a10")
End Sub