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!
|