You can click "Trace precedent" on the Formula Auditing toolbar, then
double-click on the dotted arrow line (leading from the little sheet icon) to
surface the "Go To" dialog. Then just double-click on the range in the
dialog's window and it'll zap you straight to that source range.

If the above helped you in any/some way, pl press the YES button below

p/s: Don't use all caps in your post. Hard to read & is considered impolite
nettiquette.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Ahmad" wrote:
IF I HAVE A FORMULA IN A1 CELL OF SHEET1 I.E "=SUM(SHEET2!B3:B40)",
HOW CAN I GO TO THAT RANGE WITH OUT USING SHEET TAB
WITH THE MOUSE OR alt+page down.