Hi
one way:
- start recording a macro
- set the print areas
- print each sheets separately
- stop recording

Now use this macro

--
Regards
Frank Kabel
Frankfurt, Germany

"cindy" schrieb im Newsbeitrag
...
Hi-
Hopefully someone can help me with this. I have a user,
who has a workbook, with 5 worksheets - each of them
having a range of data that needs to be printed.
Can I create a macro that will print (in one command)
each of those ranges on a separate page?
I've looked for some ideas on this, but have not been
successful - any help is appreciated!!!

thanks