Inserting HPagebreaks in excel thru. VB


Posted by Abi on February 14, 2002 8:27 AM

Iam creating an excel sheet from VB.
I tried to create horizontal pagebreak using
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
I get error message : Object doesn't support this property or method.
can anyone help me with this.
thanks.



Posted by Benedick on February 14, 2002 4:07 PM

ActiveCell.EntireRow.PageBreak = xlManual