How do I synchronize scroll split window tiles?

T

TinyRon

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

ShaneDevenshire

What version of Excel are you using? In 2002? you can use the command
Window, Compare side by side.
 
D

Dave Peterson

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
 
Top