Hi Jared,
You can delete an HPageBreak if you know which one to delete.

for example
Sheet1.HPageBreak.Item(1).Delete

This will work, provided
1) the used range is atleast up to the HPageBreak.
2) The HPageBreak is not the default excel page break (which normally is
before row 56).

SO tell me what exactly you are trying to do?
Any chance that you are confusing between, PageBreakUp and Print Area? I
got feeling that, may be what you want is actually to set a right print
area.

Sharad




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