View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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?