Thread: PrintArea
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] avpendse@gmail.com is offline
external usenet poster
 
Posts: 11
Default PrintArea

I want to set multiple print areas(approx 200 pages) on a worsheet. I
am using - ActiveSheet.PageSetup.PrintArea = ASTRING
("$A$1:$G$18,$A$20:$G$38,$A$40:$G$58,.....AND SO ON".)

This results in 1004 error as soon as the length of string "ASTRING"
exceeds 255 chars.

Any Suggestions.

Thanks.