Seems like the same topic ...

Why would this statement

ActiveSheet.HPageBreaks.Add Befo="B53"

generate a the run-time error shown in the screenshot?

Thanks,

- A

+-------------------------------------------------------------------
|Filename: HPageBreaks_Resize Error.bmp
|Download: http://www.excelforum.com/attachment.php?postid=4090
+-------------------------------------------------------------------

--
GoFigur
-----------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...nfo&userid=427
View this thread: http://www.excelforum.com/showthread.php?threadid=49000