Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
ActiveSheet.HPageBreaks not working | Excel Programming | |||
HPageBreaks.Add | Excel Worksheet Functions | |||
Activesheet.delete | Excel Programming | |||
Can't set manual HPageBreaks | Excel Programming |