spreadsheet won't fit in a single page

I have a spreadsheet that I populated from an access table (file).
when I print the data in the spreadsheet, part of the data prints on one page and the other half prints on another page. In otherwords, I have to paste two pages together to see the complete record.
I have used:

xlWksht.PageSetup.FitToPagesWide = 1
xlWksht.PageSetup.FitToPagesTall = 1

But it does not fix the problem...... Please help anyone!
Thanks
tgifgemini.

tgifgemini

Junior Poster

113 posts since Jul 2007

Reputation Points: 22

Solved Threads: 0

This article has been dead for over three months