spreadsheet won't fit in a single page

Expand Post »

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.

Similar Threads

converting from javascript to HTML? in Java
VB6/Excel - Using Char(10) to fit a long rcrdset as two lines within same recordset in Visual Basic 4 / 5 / 6
should i optimize the same keywords for each page on your site? in Search Engine Optimization
Change Web Page Font Size on the Fly in Windows tips 'n' tweaks
Help burning a Img file to single layer in Mac OS X

tgifgemini

Reputation Points: 22

Solved Threads: 0

Junior Poster

Offline

113 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Help me to read the files of Real Player (RM,RAM...etc)

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Printing in a usb port

DaniWeb Message

Cancel Changes

User Name
Password