Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ResetAllPageBreaks
Dear All,
Since moving to office 2010 a macro somthimes(! 5 %) generates error 1004 on this code ActiveSheet.ResetAllPageBreaks errortext ( my translation from Dutch ) -2147417848 automatisationerror The connection of the called objects is broken Filip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ResetAllPageBreaks
Jim,
No succes, but now I set the view to xlNormalView before 'ActiveSheet.ResetAllPageBreaks' and it seems to work. Origionally the sheet in in Pagebreakview having row 1 Frozen. Can this be the reason to trigger error on 'ActiveSheet.ResetAllPageBreaks' ? Filip "Jim Cone" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ResetAllPageBreaks
"...Row 1 Frozen. Can this be the reason to trigger error..."
It shouldn't be, but it becomes a matter of what works vs. what doesn't work. '-- Jim Cone "Filips Benoit" wrote in message ... Jim, No succes, but now I set the view to xlNormalView before 'ActiveSheet.ResetAllPageBreaks' and it seems to work. Origionally the sheet in in Pagebreakview having row 1 Frozen. Can this be the reason to trigger error on 'ActiveSheet.ResetAllPageBreaks' ? Filip "Jim Cone" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ResetAllPageBreaks
Jim,
Since starting from sheet in xlNormalView no error in about 30 test, so I think (hoop) maybe finally after 30 days the problem is solved! Filip "Jim Cone" wrote in message ... "...Row 1 Frozen. Can this be the reason to trigger error..." It shouldn't be, but it becomes a matter of what works vs. what doesn't work. '-- Jim Cone "Filips Benoit" wrote in message ... Jim, No succes, but now I set the view to xlNormalView before 'ActiveSheet.ResetAllPageBreaks' and it seems to work. Origionally the sheet in in Pagebreakview having row 1 Frozen. Can this be the reason to trigger error on 'ActiveSheet.ResetAllPageBreaks' ? Filip "Jim Cone" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|