View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nt8jbwu02@sneakemail.com is offline
external usenet poster
 
Posts: 7
Default setting page setup/print area for multiple sheets

On Oct 26, 11:10 am, "Don Guillett" wrote:
Or
for each ws in worksheets
range("a1:b6").printout
next
--



I tried this. Unfortunately, this caused the range of the current
sheet to be printed the number of times as there were sheets.

How do I indicate the range for the current ws when iterating through
the list?

-Eric