how to delete ActiveSheet.HPageBreaks.
 

hi,

here is my trouble,

i want to HPageBreak my sheet but the HPageBreaks which are made before

are obstacles,

i wonder how to delete ActiveSheet.HPageBreaks at first,


thanks

how to delete ActiveSheet.HPageBreaks.
 

ActiveSheet.ResetAllPageBreaks

NickHK

"EXCEL$B!!(BNEWS" wrote in message
...
hi,

here is my trouble,

i want to HPageBreak my sheet but the HPageBreaks which are made before

are obstacles,

i wonder how to delete ActiveSheet.HPageBreaks at first,


thanks

how to delete ActiveSheet.HPageBreaks.
 

thanks a lot ,NickHK
it really helped me

"NickHK" wrote in message
...
ActiveSheet.ResetAllPageBreaks

NickHK

"EXCEL$B!!(BNEWS" wrote in message
...
hi,

here is my trouble,

i want to HPageBreak my sheet but the HPageBreaks which are made
before

are obstacles,

i wonder how to delete ActiveSheet.HPageBreaks at first,


thanks