My booboo
for each ws in worksheets
ws.range("a1:b6").printout
next

If the range changes with each ws you will need to use something else such
as select case. What are the details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
oups.com...
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