Return an array of all page ranges in a sheet?

[slovical]

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.

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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.