Reading H Page Breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

It seems pretty easy to add a page break, but I'm trying to find the rows
where a horizontal page break exists. I've been trying use something ilke
the following to loop through them and see their location

For x = 1 To Worksheets(1).HPageBreaks.Count
debug.print Worksheets(1).HPageBreaks(x).Location
Next

but that doesn't return anything.

I have a changing report where I need to insert a line after a page break to
add a header row (the fluid part).

Any assistance is greatly appreciated!

Thanks,

kohai
 
Hello Kohai,

The Location property is a Range object. You need to only add the
Address property to return the cell's location. See Below...

For x = 1 To Worksheets(1).HPageBreaks.Count
debug.print Worksheets(1).HPageBreaks(x).Location.Address
Next

Sincerely,
Leith Ross
 
Thank you both for your replies. They will help me proceed to the next stage
of formatting my report to how I'd like it to look.

Regards,
kohai
 
Back
Top