I need to send one row at a time (or multiple selected rows), on command via
a button, to a printed, one record per page, report. I can send the record
to another worksheet or a Word document. What is the best way to accomplish
this? I am limited to working in Excel 97.

Thanks in advance.