autosize print area

  • Thread starter Thread starter Tom Pavlak
  • Start date Start date
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
 
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
 
Back
Top