Hi George,

I might be oversimplifying this...
but who says you have to "re-populate" the same sheet?

Since you're automating this *anyway* (g), I'd consider just dumping the first worksheet, reloading the template, populating it with the new data, and printing again. Yeah, it's a kludge, but it would sure save the Excedrin...

BTW, I agree about the Lotus products. I'm forced to use Notes most days at one particular location -- what a PITA.

>As anyone who has been here for any reasonable length of time may know, my loathing for Lotus products knows no bound. To-day provided another instance of one of the reasons for this. Let's cut to the chase.
>
>I'm trying to populate a 1-2-3 spreadsheet with data, clear it, re-populate it and print again. No problems with populating or clearing or printing it the first time. The second time, however, it appears that only one of the cells is being printed.
>
>In order to try and fix this, I delved into what passes for the help file. There I found a property (PrintSettings) and a constant ($CurrentSheet) to set it to, that I hope will fix this. The problem is twofold. First, no where (including the type library and the Lotus web site) does it say what object the PrintSettings property belongs to. Second, similarly and even more frustrating, the value of the constant cannot be located either.
>
>Note that all works fine with Excel and was easy to implement.
>
>Anybody got any info on this?