Thread: Print two different areas on a worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bigjim bigjim is offline
external usenet poster
  
Posts: 67
Default Print two different areas on a worksheet
I'm using excel 2003 and want to print two different areas on a sheet. Here
is the code I'm using, but when I run it, it locks up sending an error report
to MS.

ActiveSheet.PageSetup.PrintArea = "$a$1:$l$64"


ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

ActiveSheet.PageSetup.PrintArea = ""


ActiveSheet.PageSetup.PrintArea = "$a$65:$l$127"

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Reply With QuoteReply With Quote