The best I could tell, Split and Freeze are basically the same thing
underneath it all, the difference being whether you can adjust the location
of the split panes or not, and FreezePanes seems to be the toggle between
those two modes.

--
Rick (MVP - Excel)


"Jim Thomlinson" wrote in message
...
Always good to learn something new... I have seen dozens of replies to
questions on freeze panes and none of them used the split property...
--
HTH...

Jim Thomlinson


"Rick Rothstein" wrote:

Yes, just replace my example row and column values with the one's you
need)...

With ActiveWindow
.SplitColumn = 4
.SplitRow = 7
.FreezePanes = True
End With

Note: Without the FreezePanes = True statement, the worksheet will be
Split
instead of frozen.

--
Rick (MVP - Excel)


"Russ" wrote in message
...
Is it possible to freezepanes without having to first select the cell
where
you want the freeze to take place?
--
russ