Hi Eric,

to see where default pagebreaks occur for a sheet, in excel click on
View menu select 'Page Break View' then again go back to normal view
(again View menu - Normal).
It will now display both H & V pagebreaks.

Another way, just insert and run below macro to see pagebreaks in all
the sheets of the workbook:

Sub viewPbreaks()
For Each sh In ThisWorkbook.Sheets
sh.ResetAllPageBreaks
Next sh
End Sub


Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!