I have a client with a spreadsheet, need someone to fix the macros.....
"Basically the macro walks across the spreadsheet columns left to right defining various temporary variables such as Name, PYAB (Prior Years Account Balance) etc, and places them onto a "Page". Then it prints the page which is an individualized benefit statement report. The macro then advances to the next line and does it again and prints each successive page until it hits a blank line and stops.
The page information is unique for each client but he concept is the same from client to client.
This macro used to work like a charm but is not functioning properly under the new Lotus release. For one thing the Name of the person is not printing on the statement and for another the print is not properly formatted (size and orientation). "