ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert Page break in Word (https://www.excelbanter.com/excel-programming/283455-insert-page-break-word.html)

Taras

Insert Page break in Word
 
May not be the best code, but this works for me.
With xDoc
With ActiveDocument.Range
.Characters.Last.InsertBreak Type:=wdPageBreak
.InsertAfter Chr(10)
End With
End With

-----Original Message-----
I am printing comments from worksheets to Word and want

to
insert a page break in word to seperate comments on
different sheets.

The code Selection.InsertBreak type:=wdPageBreak does

not
work. It works when used in word without the connection

to
Excel.

Any idea?

Thanks for your help.
.



All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com