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
give you the row location of the first horizontal page
break:
ActiveSheet.HPageBreaks(1).Location.Row - 1
HTH