Page Breaks
 

I am unsure exactly what you need, but the following will
give you the row location of the first horizontal page
break:

ActiveSheet.HPageBreaks(1).Location.Row - 1

HTH

-----Original Message-----
Hello everyone:

Simple question:
How do I return the location of a page break?
.

Page Breaks
 

MacroMan
Thanks, It just what I needed.

Andres
-----Original Message-----
I am unsure exactly what you need, but the following will
give you the row location of the first horizontal page
break:

ActiveSheet.HPageBreaks(1).Location.Row - 1

HTH

-----Original Message-----
Hello everyone:

Simple question:
How do I return the location of a page break?
.

.