You may want to type that run time error into your message. Lots of people
don't go through excelforum and can't see your screen image.

GoFigure wrote:

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,

- Al

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

--
GoFigure
------------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...fo&userid=4274
View this thread: http://www.excelforum.com/showthread...hreadid=490001

--

Dave Peterson