Good idea. I am going to try that. I'm sure I can get the
row component of the page that way, but how about the
column component. I assume if there is only one column of
pages, there wouldn't be any vertical page breaks.
-----Original Message-----
loop through the vertical and horizontal pagebreaks
collections possibly.

--
Regards,
Tom Ogilvy



"Crosby" wrote in
message
...
Is there a way to determine the range for each of the
pages (by pages I mean the pages as they would print
out)
on a worksheet. I would like to build a new printrange
based on printing only the pages I want to print.


.