PrintOut method:

Private Sub CommandButton1_Click()
'expression.PrintOut(From, To, Copies, Preview,
ActivePrinter, PrintToFile, Collate, PrToFileName)
Worksheets("Sheet1").PrintOut , copies:=3
End Sub






-----Original Message-----
Excel 2002.

Where is the setting to programmatically print a
specified number of
pages per physical sheet of paper in VBA? I recorded a
macro, but did
not see the proper property there. Also, I do not see it
in the Object
Browser. I am specifically talking about File | Page
Setup... | Options
| Pages per sheet.

Any help would be most appreciated.
.