Application GoTo solution ?

[stuartgb100]

Hi,

I have two Windows open, each displaying a different worksheet from the activeworkbook.

Window2 is active, and it has a formula in E35 as follows: ='Dim Sheet'!$A$8.

This is pointing to Window1

Can I use Application.GoTo to scroll Widow1 and bring A8 into view ?

So far I've had no success, but (not working) I have:

Please Login or Register  to view this content.

Any help would be much appreciated, please.

[mahaveersomani]

I think you can use ctrl+[ key on E35 cell.

[stuartgb100]

Hi, and thanks.

Is this something I can do with VBA ?

Apologies if I did not make it clear that I was looking for a code solution.

[mahaveersomani]

for every cell in which these type of formulas. i think you can use.

ActiveCell.DirectPrecedents.Select