Hi Frick

Start here
http://www.rondebruin.nl/print.htm

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


"Frick" wrote in message ...
I have a report that pulls data from another worksheet in Range A26:J58. What I want to be able to do is assign a button for
printing the report but before printing from A1:J70 removing or hiding any row in the A26:J58 range where there is no data. The
range is filled from row 26 down so it is not a random fill.

Also, I want to save this workbook as a template so that it can be used over again, so I guess it would not be good to delete the
rows in the range otherwise I would have to recreate them.

Thanks for your help.