Guest_imported
New member
- Jan 1, 1970
- 0
hi,
I`m having a problem while using HPageBreaks from VBA to get the number of page breaks that was automatically inserted by Excel. HPageBreaks.Count is returning 2 while there are 3 page breaks in my worksheet. I`m using HPageBreaks.Location.Row to get the current row where the Page Breaks occur but it is missing the 2nd page break. What i`m trying to do is to spot where excel has inserted page breaks so as i can insert a specific header depending on the section printed.
Does anyone know how I can locate the position of all Page Breaks that were inserted by excel?
Any help would be most welcomed.
Thanx
vik.
I`m having a problem while using HPageBreaks from VBA to get the number of page breaks that was automatically inserted by Excel. HPageBreaks.Count is returning 2 while there are 3 page breaks in my worksheet. I`m using HPageBreaks.Location.Row to get the current row where the Page Breaks occur but it is missing the 2nd page break. What i`m trying to do is to spot where excel has inserted page breaks so as i can insert a specific header depending on the section printed.
Does anyone know how I can locate the position of all Page Breaks that were inserted by excel?
Any help would be most welcomed.
Thanx
vik.