Thread
:
CUSTOM PRINTING !
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
CUSTOM PRINTING !
Or even
Range("A1:N50").PrintOut
Range("A51:N90").PrintOut
--
Don Guillett
SalesAid Software
"Gleam" wrote in message
...
I find tools /macro /record new macro very useful.
Here is what it gives for a similar problem
Range("A1:B2").Select
Selection.PrintOut Copies:=1, Collate:=True
Range("A3:E5").Select
Selection.PrintOut Copies:=1, Collate:=True
This can be simplified to
Range("A1:N50").PrintOut Copies:=1, Collate:=True
Range("A51:N90").PrintOut Copies:=1, Collate:=True
"jay dean" wrote:
This macro will set the page up such that the page will print as two
pages...
Range("A1:N50") will print as one page, and
Range("A51:N90") will print as the second page.
**Please, I will NEED a macro for numerous reasons.
Any help will be appreciated! Thanks
Jay
*** Sent via Developersdex
http://www.developersdex.com
***
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett