tgifgemini 12 Junior Poster

Hello everyone,
I am using VB6 to generate a report in Excel but I am having a printing problem. I generated a spreadsheet using an access file. The data in the spreadsheet stretches all the way from Column A through S.
When I print, columns A through M prints on one page and columns N through S prints on another page, splitting the spreadsheet data into two separate pages. How can I get the whole spreadsheet to print on one page: I mean columns A through S to print on the same page.

Note: I have used the "FitTopage" function, buy that's not working.
Thanks.
Giftx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.