page break setup

  1. S

    VBA Code to remove page breaks giving range error HELP

    I am unable to figure out how to write the VBA code to ignore page breaks if certain rows are hidden / allow page breaks if rows are not hidden. I am new to VBA code writing. I have checkboxes that when selected the rows will hide or expand when checked. I have the following print command...
  2. J

    Excel to Word page break

    Hi All, yesterday I've been helped beautifully and now I'm stuck again...:confused: My code now copies ranges from Excel to Word nicely, but I need to add page breaks. If I just run the code wdDoc.Range(wdDoc.Content.End - 1).InsertBreak Type:=7 it works, but when added to the existing code...
  3. K

    printing duplex with different sheets on page 1 & same sheet page 2

    Sorry if this question has been asked before. am using excel97. I have dozens of worksheets all different, I want to be able to print all these duplex The sheets have all previously been set up as 1 page containing only the ranges required. Odd pages should change but even pages should remain...
  4. SonGunnar

    Insert Page Breaks and Adjust Rows XL2003

    Problems: Groups of data should not split at inserted page breaks. Row heights vary at the 3rd and 5th row of each 7 row group. Typical pages have between 4 and 6 groups. Average projects contain 10 - 50 pages, or 40 - 250 groups. What I am trying to do is adjust the height of every 5th and 7th...
  5. W

    Automatically Resize Entire Workbook

    Hi Everyone, I have a 40+ page workbook that I'm working and I need to print every sheet in the workbook on legal size paper, and each sheet can not be > one legal piece of paper The macro will cycle thru all the sheets in the workbook, yet it will only adjust the current active sheet. I...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top