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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section Breaks 0
get application, object error 11
runtime error 9 subscript out of range #3 3
Page Break Problem 0
runtime error #9 subscript out of bounds #4 2
run time error #9, subscript out of range 4
Two columns followed by single page-width column on same page 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0

Top