Printing page 1 from each sheet in workbook
 

I have multiple worksheets with a similar layout.
I need to print only page X of 4 from each worksheet in the file.
How can I do this with vba?

Printing page 1 from each sheet in workbook
 

See the PrintOut method in vba help.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/SpecialPrint

..
..
..

"Steven Grimaldi"

wrote in message
...
I have multiple worksheets with a similar layout.
I need to print only page X of 4 from each worksheet in the file.
How can I do this with vba?

Printing page 1 from each sheet in workbook
 

On Jul 28, 12:10*pm, "Jim Cone" wrote:
See the PrintOut method in vba help.
--
Jim Cone
Portland, Oregon *USAhttp://tinyurl.com/SpecialPrint

.
.
.

"Steven Grimaldi"

wrote in ...
I have multiple worksheets with a similar layout.
I need to print only page X of 4 from each worksheet in the file.
How can I do this with vba?

Something like this ??

Sub printareafromsheets()
For i = 1 To 4
Sheets(i).Range("a1:z21").PrintPreview 'printout
Next
End Sub