Application.GoTo a Range in another Window

sgbooth · #1 11-21-2015, 02:20 AM

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.

shg · #2 11-21-2015, 12:19 PM

Code:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting a contents with a "GOTO"	jrmourning	Word	1	11-21-2014 07:03 AM
Word GoTo From Excel	mata30s	Word VBA	14	12-10-2012 09:36 AM
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err	tinfanide	Excel Programming	2	06-09-2012 10:19 AM
What application to use?	pfergy	Office	1	03-12-2011 08:46 PM
Best application to use?	FrankW	Office	2	06-13-2009 01:16 AM