Or
for each ws in worksheets
range("a1:b6").printout
next
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ups.com...
I have an excel file with many sheets. I would like to do the same
'Page Setup' and 'Print Area -Set Print Area' for every page in the
file. Is there a way to do this without having to do each sheet
manually?

Thanks.