Thread: Can you get the range reference for each page in a worksheet print range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Can you get the range reference for each page in a worksheet print range?
loop through the vertical and horizontal pagebreaks collections possibly.

--
Regards,
Tom Ogilvy



"Crosby" wrote in message
...
Is there a way to determine the range for each of the
pages (by pages I mean the pages as they would print out)
on a worksheet. I would like to build a new printrange
based on printing only the pages I want to print.


Reply With QuoteReply With Quote