[AccessD] OT: Excel - Print Area

Solved...

I figured out that it is a combination of not only hiding rows and
columns, but also re-setting the page breaks while in page-break view.
 Thanks for the help.


Mark



On Tue, 15 Feb 2005 13:28:26 -0600, Hale, Jim <Jim.Hale at fleetpride.com> wrote:
> Also check out <views> <custom views> which allow you do define and save
> multiple print settings per sheet.
> Jim Hale
> 
> -----Original Message-----
> From: Jim Hewson [mailto:JHewson at karta.com]
> Sent: Tuesday, February 15, 2005 1:18 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] OT: Excel - Print Area
> 
> If you hide the columns and rows you don't want printed then you can get the
> print area you need.
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Admin Sparky
> Sent: Tuesday, February 15, 2005 1:05 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] OT: Excel - Print Area
> 
> Group,
> 
> Quick question.  Is there a method to choose non-adjoining areas of a
> spreadsheet and print them as a single (apparently adjoining) area?
> 
> For instance...a header row of columns A, C, E, and detail rows
> 100-103 for each of those columns?
> 
> When choosing a print area, I have tried holding down control to pick
> several areas and that part works, however each section prints on a
> separate page.
> 
> Mark
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> ***********************************************************************
> The information transmitted is intended solely for the individual or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of or taking action in reliance upon this information by
> persons or entities other than the intended recipient is prohibited.
> If you have received this email in error please contact the sender and
> delete the material from any computer. As a recipient of this email,
> you are responsible for screening its contents and the contents of any
> attachments for the presence of viruses. No liability is accepted for
> any damages caused by any virus transmitted by this email.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
>