#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |