View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default ResetAllPageBreaks

I don't have an explanation/reason for you.
An alternative you can try is...

Cells.PageBreak = xlNone

--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL
(free trial - commercial add-in)

..
..
..

"Filips Benoit"
wrote in message
...
Dear All,

Since moving to office 2010 a macro somthimes (! 5 %) generates error 1004 on
this code

ActiveSheet.ResetAllPageBreaks


error text ( my translation from Dutch )
-2147417848 automatisation error
The connection of the called objects is broken
Filip