ExcelBanter - Solution on previous threat 17/10 about error 1004 while inserting HPageBreak by code

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Solution on previous threat 17/10 about error 1004 while inserting HPageBreak by code (https://www.excelbanter.com/excel-programming/399624-solution-previous-threat-17-10-about-error-1004-while-inserting-hpagebreak-code.html)

Filips Benoit[_2_]

Solution on previous threat 17/10 about error 1004 while inserting HPageBreak by code

Dear All,

Problem: The code could not isert a HPageBreak in the active PrintArea !!!

I added 1 codeline to clear the PrintArea
ActiveSheet.PageSetup.PrintArea = ""

Filip

I added the solution in the original threat to !

All times are GMT +1. The time now is 03:32 PM.