| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete all page breaks?
I've been banging my head on my desk for a day trying to figure this out.
Does anyone have a working example of how to do this? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete all page breaks?
Hi Mchastant,
To remove all manual pagebreaks try: Activesheet.Cells.PageBreak = xlPageBreakNone --- Regards, Norman "mchastant" wrote in message ... I've been banging my head on my desk for a day trying to figure this out. Does anyone have a working example of how to do this? Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete all page breaks?
How about automatic pagebreaks?
"Norman Jones" wrote: Hi Mchastant, To remove all manual pagebreaks try: Activesheet.Cells.PageBreak = xlPageBreakNone --- Regards, Norman "mchastant" wrote in message ... I've been banging my head on my desk for a day trying to figure this out. Does anyone have a working example of how to do this? Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to delete all page breaks?
Hi Mchastant,
How about automatic pagebreaks? Automatic page breaks cannot be deleted. If you wish turn off the display of manual and automatic pagebreaks, try: Application.DisplayPageBreaks = False --- Regards, Norman "mchastant" wrote in message ... How about automatic pagebreaks? "Norman Jones" wrote: Hi Mchastant, To remove all manual pagebreaks try: Activesheet.Cells.PageBreak = xlPageBreakNone --- Regards, Norman "mchastant" wrote in message ... I've been banging my head on my desk for a day trying to figure this out. Does anyone have a working example of how to do this? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i delete automatic page breaks in excel | New Users to Excel | |||
| can one delete or change automatic page breaks? | Excel Worksheet Functions | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| How do I delete page breaks from my documents? | Excel Discussion (Misc queries) | |||
| Delete unwanted page breaks. | Excel Worksheet Functions | |||
Linear Mode
