Thread: HPageBreak not working
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default HPageBreak not working
Hi,

Am Sat, 13 Oct 2012 09:28:50 -0400 schrieb :

I am using Excel 2003 (ancient like me). I can insert an entry into the
HPageBreaks collection by "Insert/PageBreak" in Excel or by
ActivePage.HPageBreaks.add befo=Range("A28")
in VBA.

try it with:
ActiveSheet.HPageBreaks.Add Range("A28")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote