I am using the following snippet of code to try and freeze the left 4 columns and the upper 4 rows
Worksheets("Sheet1").Activate
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = StartPlace - 4
ActiveWindow.FreezePanes = False
With ActiveWindow
10 .SplitColumn = StartPlace - 4
.SplitRow = 5
.FreezePanes = True
End With
End Sub
Freeze panes works on the SplitRow = 4
It does not appear to be working on SplitColumn = StartPlace-4 (= 2224) I have searched for a column which is not the one I needed that is Frozen but Have not found it.
I have also tried adding another FreezePanes =True after row 10 still not working. I have attached a copy of the important part of the worksheet. Can some body show me where I have gone wrong?
Bookmarks