Landscape print with Letter paging

M

MacroMan

Please Help!

I am using VBA in Excel XP with Windows 2000.

I have many spreadsheets (more than 50), some consisting
of several pages each, that are preformatted for LANDSCAPE
printing and need to stay the way they are currently
formatted (by boss).

These formatted pages are to be published and when
printed, need to have a page number placed in the top
right corner, but rotated from landscape to LETTER, so the
finished pages appear like in a book, all paging facing
the same way.

Any ideas for an easy way to accomplish this?

Your example code would be greatly appreciated. Thanks in
advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Space at end of multi page list to accommodate new entries 1
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
Publisher is filling blank lines with data 2
how to rotate page numbers in landscape mode? 1
Problem with SET & REF function 0
Printing userform in landscape on one page only 2
need to make a brochure 1

Top