printing with out data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pgarcia - 12 Dec 2007 22:16 GMT

I've setup a spreed sheet that has formulas from A19:Q1000. You can not see
the formula in less there is data. How can I print out the visable data and
not have Excel want to print out 20 pages with now visable data? e.g. page 1
has data from A1:Q30.

Also, can you suppres the "PAGE 1" in the middle of the sheet?

Thanks

Reply to this Message

JLGWhiz - 12 Dec 2007 22:58 GMT

You can manually set the print area of a file. Check the help file for Print
Area

> I've setup a spreed sheet that has formulas from A19:Q1000. You can not see
> the formula in less there is data. How can I print out the visable data and
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

pgarcia - 13 Dec 2007 13:27 GMT

Yes, I know. But I was looking for a VB code to just select the print area
for me as the data changes daily.

> You can manually set the print area of a file. Check the help file for Print
> Area
[quoted text clipped - 7 lines]
> >
> > Thanks

Reply to this Message