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 Return an array of all page ranges in a sheet?

what do you mean by range addresses for each page. Do you mean the used
range of the page?

--
Regards,
Tom Ogilvy

"slovical" wrote in message
...
Hello,

Does anyone out there know of a way (or have VBA code) to return the

individual range addresses for each page that resides in a particular sheet,
perhaps in an array?

This would be of immense help to me. Your example code would be most

beneficial. Thank you very much in advance.