delete multiple pagebreaks
In Excel2000, how do I combine these statements into one (for rows 5-6):
For Each sht In ActiveWindow.SelectedSheets
sht.Rows(5).PageBreak = xlNone
sht.Rows(6).PageBreak = xlNone
Next
I wanted somtething like this (but it does not work):
sht.Rows(5, 6).PageBreak = xlNone
Thanks
|