Thread: Recorded Macro to Set page breaks generates error.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jared Jared is offline
external usenet poster
  
Posts: 109
Default Recorded Macro to Set page breaks generates error.
I recorded a Macro to generate page breaks. The code is:

ActiveSheet.ResetAllPageBreaks
Set ActiveSheet.HPageBreaks(1).Location = Range("A68")

When I try to run this macro, I get Runtime Error '1004', Application or
Object defined error. Does anybody know of a way to do this?
Reply With QuoteReply With Quote