ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I synchronize scroll split window tiles? (https://www.excelbanter.com/excel-worksheet-functions/131239-how-do-i-synchronize-scroll-split-window-tiles.html)

TinyRon

How do I synchronize scroll split window tiles?
 
I have two vertical split panes and I want them to scroll together so they
stay lined up. Anyone know how? Thnaks.

ShaneDevenshire

How do I synchronize scroll split window tiles?
 
What version of Excel are you using? In 2002? you can use the command
Window, Compare side by side.
--
Thanks,
Shane Devenshire


"TinyRon" wrote:

I have two vertical split panes and I want them to scroll together so they
stay lined up. Anyone know how? Thnaks.


Dave Peterson

How do I synchronize scroll split window tiles?
 
This kind of macro worked for me in xl2003 if both windows were showing the same
worksheet:

Option Explicit
Sub SyncWindows()
Windows.Arrange ActiveWorkbook:=True, _
synchorizontal:=True, syncvertical:=True
End Sub

TinyRon wrote:

I have two vertical split panes and I want them to scroll together so they
stay lined up. Anyone know how? Thnaks.


--

Dave Peterson


All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com