Thread: Recorded Macro to Set page breaks generates error.
View Single Post
  #11   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've entered the following code:

Workbooks(ExWBName).Sheets("Market Pene.").PageSetup.FitToPagesWide = 1
Workbooks(ExWBName).Sheets("Market Pene.").PageSetup.FitToPagesTall = 2
Workbooks(ExWBName).Sheets("Market Pene.").Rows(68).PageBreak =
xlPageBreakManual

It runs, but it is not generating a break at row 68.
"Jared" wrote:

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