.hpagebreaks.add

  1. kelly mort

    Page Break code Adjustment needed

    Hi , Instead of hardcoding the number of rows to set the pagebreak into the script, I want to set that dynamically using some criteria: In column B, I have say x, y, z, etc. they are sorted so all x before all y then all z etc. so I want to set the pagebreak to match the x items then the y items...
  2. D

    VBA to apply macro to selected sheets

    Hello, I've been dabbling with macros recently, but have not found a way to apply macros to selected sheets in the workbook. The macro I have works flawlessly on the active sheet, it applies the proper page breaks and if a certain section is completely hidden it won't print the page. Below is...
    • Daystep
    • Thread
    • .hpagebreaks.add before=.cells749 breaks end page
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top