tgifgemini 12 Junior Poster

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.