Page Breaks

M

MacroMan

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
 
A

andres a.

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

.
Click to expand...
 
Top