Print Problem

[jjj]

Hi,

I have a sheet within my workbook which imports data from Access i
table and pivot formats. I want to have a print button on the pag
which prints my page on 1 sheet, but am never sure of how much data ma
be dropped in from Access, so i need a bit of code i think which wil
only print down and across as far as the data goes on one sheet (so th
exact opposite of selecting the print area then printing!).

Can anyone hel

 

[Jim Rech]

Go into Page Setup while in this worksheet and on the Page tab select "Fit
to" of 1 page wide and 1 page long. Thereafter no matter how much data is
on the sheet it will print on only one sheet of paper.

--
Jim Rech
Excel MVP
|
| Hi,
|
| I have a sheet within my workbook which imports data from Access in
| table and pivot formats. I want to have a print button on the page
| which prints my page on 1 sheet, but am never sure of how much data may
| be dropped in from Access, so i need a bit of code i think which will
| only print down and across as far as the data goes on one sheet (so the
| exact opposite of selecting the print area then printing!).
|
| Can anyone help
|
|
| --
| jjj
| ------------------------------------------------------------------------
| jjj's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=7424
| View this thread: http://www.excelforum.com/showthread.php?threadid=277042
|