Unable to insert a page break
 

I cannot insert a page break on several sheets in my workbook.
I have tried inserting a page break in my code and also manually.
Any ideas?

Unable to insert a page break
 

Do you have an active printer.

Sub TestPrinter()
msgbox Application.ActivePrinter
End Sub

If so, what leads you to believe it wasn't inserted. Have you look in
View=Pagebreak Preview

--
Regards,
Tom Ogilvy


" wrote:

I cannot insert a page break on several sheets in my workbook.
I have tried inserting a page break in my code and also manually.
Any ideas?