I wish to have both left and right hand panes static and scrolling (left to
right) columns in between. Can this be done?

You get one Window|freeze panes (or window|Split) per window.

But you could use multiple windows into that worksheet:

Window|new window
window arrange (vertical???)

And have two windows showing the same worksheet.

Click on the one you don't want and hit ctrl-w to close it when you're finished.

Secret Genius wrote:

I wish to have both left and right hand panes static and scrolling (left to
right) columns in between. Can this be done?

--

Dave Peterson

That's brilliant thanks very much.

Question is, can you scroll them together?.....

Secret Genius.

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


Secret Genius wrote:

That's brilliant thanks very much.

Question is, can you scroll them together?.....

Secret Genius.

--

Dave Peterson