Posted by Kev Tweddle on December 27, 2001 2:11 AM
I have a problem with the page format, I have four tables of data under each other and to the right of each table is a 3D Pie chart.
The problem is that the tabels and the graphs cover all pages when I look at Print Preview.
I used the following code to try and fit everything onto one page:
.FitToPagesWide = 1
.FitToPagesTall = 1
Apparently in Excel 97 this does not work. Does anybody have any other ideas as to how I can fit everything onto one page.
I can manually adjust the pagebreak and it works, I think there is a command called Adjust, but I'm not sure how to use it.
Can anybody help?