Application.GoTo a Range in another Window

[sgbooth]

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 I have:

Application.Goto Windows(1) 'Dim Sheet'!$A$8, Scroll:=true

Any help would be much appreciated, please.

[shg]

Application.Goto Worksheets("Dim Sheet").Range("A8") Scroll:=True