Print macro for multiple ranges/sheets
 

Take a look here Deeds
http://www.rondebruin.nl/print.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Deeds" wrote in message ...
I am trying to write a macro that prints/previews multiple ranges across several sheets. Any ideas?
Thanks

Print macro for multiple ranges/sheets
 

Thanks. My problem is the following: I am trying to write a macro or code that when a button is pressed it previews 5 different named ranges of area which I can click "next" in the preview window to look at. Is there language to say named range 1, named range 2, named range 3 to preview
Thanks