Tracing offsets

[cdegar01]

Let’s say I have the following formula in cell A1:


=OFFSET(INDIRECT(M4),22,4)


This returns the value 14.04


M4:

=CELL("address",'[Book1]Sheet1'!A36)


So basically, offset 22,4 from '[Book1]Sheet1'!A36 is the targe
14.04.



While in the original cell A1, I want a way to be able to press
couple buttons (run a macro) and then have the cursor go to the targe
cell that contains 14.04.



Is this possible? Thanks,

Chri

 

[Andy B]

Hi

This may be what you are looking for - but it may not!
Have a look at Tools / Auditing. From there you can Trace Precedents (cells
that this cell 'depends' on) and Trace Dependents (cells that 'depend' on
this cell). It draws links between these cells and double-clicking the link
will take you to the linked cell - or the GoTo cells dialog with the linked
cell listed..
I haven't tried it with Offset and Indirect, but give it a go and let me
know!!

 

[cdegar01]

That doesn't work with offsets, but thanks