View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fredrik fredrik is offline
external usenet poster
 
Posts: 11
Default Printing forom different tabs

I want to print just the first page from several tabs in a workbook.
The code is:

ActiveSheet.PrintOut From:=1, To:=1, Copies:=1

But how do I write the macro so that the printing selection is repeated for
the next tab until the end of the workbook?