Hi Don
Try
Sub Macropagebreak()
For Each CELL In Range("A:A")
If CELL = "BREAK" Then
CELL.Rows.Select
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
Else
End If
Next
End Sub

"Don" wrote:

> Is it possible to insert a page break automatically when specific text is
> encountered in row A. This report is hundreds of pages long and I need an
> automatic page insert macro. Can someone give me the syntax of a macro if
> the specific text is "Break"? Thanks for any help.
>
> --
> Don Rountree