Thread: [Solved] Application.GoTo a Range in another Window
View Single Post
 
Old 11-21-2015, 02:20 AM
sgbooth sgbooth is offline Windows 7 Office 2007
Novice
  
Join Date: Aug 2010
Posts: 2
sgbooth is on a distinguished road
Default Application.GoTo a Range in another Window
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:

Code:
Application.Goto Windows(1) 'Dim Sheet'!$A$8, Scroll:=true
Any help would be much appreciated, please.
Reply With Quote