Page Break Preview
 

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!

Page Break Preview
 

http://www.j-walk.com/ss/excel/usert...intingtips.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!

Page Break Preview
 

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/usert...intingtips.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!

Page Break Preview
 

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/usert...intingtips.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!

Page Break Preview
 

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:

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/usert...intingtips.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!