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?

By this I mean the range address of any given page on a sheet. So if there were two pages set to print on a single sheet, the array might return "A1:J47" for page 1 and "A48:J63" for page two.

This would be of immense help to me. Your example code would be most beneficial. Thank you very much in advance.