View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Howard Eric Howard is offline
external usenet poster
 
Posts: 4
Default Range use on page

Is there a way to determine the range of cells on a page using VBA?

I'm defining a page as the cells within a series of page breaks, automatic
or manual. So if it worksheet contains items in the first 3 rows and 5
columns, then usedrange property would return the first 3 rows and 5 columns.
However after a print preview Excel displays page breaks after column I and
after row 52. How can I determine this range through VBA, since these page
breaks do not appear through HPagebreaks or VPagebreaks.
--
Eric Howard
Director of Process Automation
Synergis Technologies, Inc.