Group:  Microsoft Excel ยป microsoft.public.excel.misc
Thread: Page Break Preview

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Page Break Preview
stenz 26.09.2006 14:07:03
Is there any way to remove blank pages that are revealed in the page break
preview? Resetting print area will get rid of some at the end, but I need to
remove dozens from the middle of documents. Is there a way to do this with a
macro? Thanks!
RE: Page Break Preview
Marcelo 26.09.2006 14:17:01
http://www.j-walk.com/ss/excel/usertips/printingtips.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"stenz" escreveu:

[Quoted Text]
> Is there any way to remove blank pages that are revealed in the page break
> preview? Resetting print area will get rid of some at the end, but I need to
> remove dozens from the middle of documents. Is there a way to do this with a
> macro? Thanks!
RE: Page Break Preview
stenz 26.09.2006 14:20:02
Thanks, but not what I was looking for. I'm looking for a shortcut so I
don't need to select my print range(s).

"Marcelo" wrote:

[Quoted Text]
> http://www.j-walk.com/ss/excel/usertips/printingtips.htm
>
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "stenz" escreveu:
>
> > Is there any way to remove blank pages that are revealed in the page break
> > preview? Resetting print area will get rid of some at the end, but I need to
> > remove dozens from the middle of documents. Is there a way to do this with a
> > macro? Thanks!
RE: Page Break Preview
Marcelo 26.09.2006 14:31:02
what about this?
http://mcgimpsey.com/excel/noprintrange.html

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"stenz" escreveu:

[Quoted Text]
> Thanks, but not what I was looking for. I'm looking for a shortcut so I
> don't need to select my print range(s).
>
> "Marcelo" wrote:
>
> > http://www.j-walk.com/ss/excel/usertips/printingtips.htm
> >
> > hth
> > --
> > regards from Brazil
> > Thanks in advance for your feedback.
> > Marcelo
> >
> >
> >
> > "stenz" escreveu:
> >
> > > Is there any way to remove blank pages that are revealed in the page break
> > > preview? Resetting print area will get rid of some at the end, but I need to
> > > remove dozens from the middle of documents. Is there a way to do this with a
> > > macro? Thanks!
RE: Page Break Preview
stenz 26.09.2006 14:40:02
Not that one either. I'm looking to get away from manually selecting no
print ranges, since almost every single doc is different, and I can't rely on
a set range. Ultimately, I want to hit ctrl x and have excel remove all
blank pages regardless of location in the document, with out me specifying
where.

Thanks!

"Marcelo" wrote:

[Quoted Text]
> what about this?
> http://mcgimpsey.com/excel/noprintrange.html
>
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "stenz" escreveu:
>
> > Thanks, but not what I was looking for. I'm looking for a shortcut so I
> > don't need to select my print range(s).
> >
> > "Marcelo" wrote:
> >
> > > http://www.j-walk.com/ss/excel/usertips/printingtips.htm
> > >
> > > hth
> > > --
> > > regards from Brazil
> > > Thanks in advance for your feedback.
> > > Marcelo
> > >
> > >
> > >
> > > "stenz" escreveu:
> > >
> > > > Is there any way to remove blank pages that are revealed in the page break
> > > > preview? Resetting print area will get rid of some at the end, but I need to
> > > > remove dozens from the middle of documents. Is there a way to do this with a
> > > > macro? Thanks!

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net