ScrollArea Property Example
This example sets the scroll area for worksheet one.
Worksheets(1).ScrollArea = "a1:f10"