Hi Alan,
glad you find my site useful.

That was literally stepping back and looking at it from a distance.

How did you did you ever discover the unusual high number of rows
for freeze panes.

"Allan Seidel" wrote ...
Thanks for your site David. I used it to get me started in Excel VBA and
I go there every once and a while. The no scrolling problem turned out
to be a normal Excel function, or should I say pitfall.

Apparently the user created their Custom view, which was an autofiltered
table segment view deep into the table - say at row 120 , after they had
reset the freeze pane. Therefore the freeze was at row 119 instead of
at row 6.