anyone?????????????

Hi,

I have this code which I am using to add a page break to an excel document that I have created through code.

VB Code:

With excelApp
            .rows(tempRow).Select
            .ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
End With

I get this message which breaks on the page break line
"Run time error '1004':
Application-defined or object-defined error"

Am I not doing this right? or could something else be causing this problem.

Any help would be greatly appreciated.