Thread: HPageBreak Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default 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.