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?
.