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