autosize print area

T

Tom Pavlak

I am using FoxPro to programmatically create a Sheet, I have hidden
cells that currently don't get printed out.

my problem is, I am using this osheet.pagesetup.printarea =
"$A$1:I$180".

this is ok for 90% of the sheets, there are times when the sheet will
go past i180 and thus data will get cut off during printing.

I have tried not using the above and my hidden cells get printed. I
have tried to use the 'usedrange' but the hidden cells get printed.

the hidden cells are 2 columns away with blanks between.

how do I make my print area grow or shrink with the sheet?

Regards,

Tom Pavlak
 
E

Earl Kiosterud

Tom,

If the rows or columns are hidden when the print command is issued, they
should not print. You could move those cells to another sheet. Use
Cut/Paste. Any cell references should follow.

Earl Kiosterud
www.smokeylake.com
 
Top