Thread: Printing
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Printing

Worksheets("Sheet" & Coun).PageSetup.PrintArea

--
Jim
"Brent" wrote in message
...
| Is there a way to use the command
|
| Worksheets("Sheet?").PageSetup.PrintArea......
|
| Where ? increments. Or some function that would print consecutive sheets
| through the for loop?