pagebreak in excel printing

[AgatheB]

Hi there!

I'm using some code to print 4 periods continuously, but with the code below nothing happens.....


For Each One_break In ActiveSheet.HPageBreaks
One_break.Delete
Next

(The code loops 3 times, but on MsgBox "Breaks: " & ActiveSheet.HPageBreaks.Count i get the value 3....)

Any suggestions?

Agathe

 

[AgatheB]

Sorry, it's not that i can't print, I just can't get rid of those pagebreaks....

Agathe

 

[AgatheB]

Found out about it:

ActiveSheet.ResetAllPageBreaks

(How hard can it be? ;-))

There's not so much info on this subject on the internet (or I just look the wrong places....)