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