Every cell has a page break?!?!
Right-click the sheet tab and select "View Code"
Paste this macro in:
Private Sub fixbreaks()
ActiveSheet.ResetAllPageBreaks
End Sub
Hit the green play button.
Ctrl+A to select the entire macro, then hit the Delete key.
Alt+Q to get out of the macro editing window.
That should take care of it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.
"Garyntx" wrote:
tried that. the lines go away but it still wants to print each cell
separately and will not let you remove the page breaks.
"Pokey" wrote:
You should be able to go to view and hit normal right above page break preview.
|