printing ranges ina macro

C

cindy

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
 
F

Frank Kabel

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

Now use this macro
 
Top