Reading the PrintArea Pages
Before I start on VBA code to do this, I figured I'd ask if anyone has
already has code to do something close or suggestions on how to approach it.
The functions I'm looking for a
1. NumberOfPrintPages (returns the number of pages setup for printing)
Will this equation do it?
((activesheet.hpagebreaks.count+1) * (activesheet.vpagebreaks.count+1))
2. PrintPageAreas (returns an array containing the Range (or address) of
each print page
This one is a bit more complex. I need to know the range of each page
area.
Thanks,
- Pat
|