View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default Reading the PrintArea Pages

Pat wrote:
<<Is there any place I can find the definitions of them?

ActiveSheet.PageSetup.PrintArea

.... will return a string that represents the print area on the active sheet
(i.e. "$A$1:$P$27").

You would then have to write a routine to count how many page breaks are
inside this area (subset of the whole page), if you want to know how many
printed pages the print area would be.

--
Regards,
Bill Renaud