HPageBreak Row
 

What would be the easiest way to get the row number of certain HPageBreak
(first , fifth...) on active sheet.

Thanks, Oscar.

HPageBreak Row
 

r = activesheet.hpagebreaks(1).location.row

Replace 1 with desired PB's number

HTH
--
AP

"Oscar" a écrit dans le message de news:
...
What would be the easiest way to get the row number of certain HPageBreak
(first , fifth...) on active sheet.

Thanks, Oscar.