FreezePanes Method Example

This example splits the worksheet window at row 5 and freezes the pane above the split.

Set c = Spreadsheet1.Constants
Spreadsheet1.Range("b5").FreezePanes c.ssFreezeTop