View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex T Alex T is offline
external usenet poster
 
Posts: 24
Default Finding the current "print range"

Folks

I am trying to build a function that would take as parameter a single
cell and would return a range corresponding to the area that would
print on the same page than the said cell.
I know that recent XL versions have a "page break preview" mode that
does everything I'm looking for... but it doesn't seem to be
accessible from the object model.

Any idea ? I'm pretty sure this is a common question...

Regards

--alexT