View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500[_2_] snax500[_2_] is offline
external usenet poster
 
Posts: 29
Default 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