Page breaks

[Guest]

I need to find out 'on the fly' where the page breaks on a worksheet are. If
I run my macro, the property ActiveWorkbook.WorkSheets(1).HPageBreaks.Count
or ActiveWorkbook.WorkSheets(1).VPageBreaks.Count is always 0. I would be
glad if somebody could possibly help me, or just gaev me some link where
could I find it.

 

[Ron de Bruin]

Hi

I run my macro, the property ActiveWorkbook.WorkSheets(1).HPageBreaks.Count
or ActiveWorkbook.WorkSheets(1).VPageBreaks.Count is always 0.

Very strange
Do you have a hidden worksheet in the first position

See this example and look for Location.row in the code
http://www.rondebruin.nl/hpagebreaks.htm