How do I synchronize scroll split window tiles?

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I lock a section of cells in place 1
Vertical Split with separate vertical scrolls? 0
How do I get the horizontal split box back? 5
Un-Synchronous Panes 3
Split screens 1
Mobile phone texts split into incoming and outgoing messages 0
Freeze and split panes in Excel 2003 1
horizontal scroll bar 1

Top