Hi kohai

Look at this macro
http://www.rondebruin.nl/hpagebreaks.htm

read about the bug in the macro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"kohai" wrote in message ...
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