Return an array of all page ranges in a sheet?
 

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.

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.