Page Breaks

  • Thread starter Thread starter MacroMan
  • Start date Start date
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
 
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

.
 
Back
Top