Return an array of all page ranges in a sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
what do you mean by range addresses for each page. Do you mean the used
range of the page?

--
Regards,
Tom Ogilvy

slovical said:
Hello,

Does anyone out there know of a way (or have VBA code) to return the
Click to expand...
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
Click to expand...
beneficial. Thank you very much in advance.
 
Back
Top