hi, ?

AFAIK, what you need could suffer variations depending on non/controlled events
(i.e. changing page-setup/printer resolution/quality, pint area-titles, printing order, and so on)

i guess you could seek for options/alternates in the following pages:

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

regards,
hector.

__ OP __
... I need a function that will retrieve the range address of each defined page range on a sheet.
For example, if page one is set to A2:H50, and page two is set to A51:H80
I need to retrieve each of these sets of ranges.
The number of pages may vary at different times.
I would prefer to work with an array if possible.
Your assistance in the form of example code would be greatly appreciated.