pagebreak

  1. T

    Pasting several tables in Word with pagebreak after each one

    I have hundreds of excel sheets that need to be pasted into Word with a pagebreak between them. I have tried SEVERAL different codes, and I only either get 1 table pasted, or 40 pagebreaks with no tables at all. How do I paste a table, add a pagebreak after the table, and then add another table...
  2. O

    Unable to set PageBReak property of Range Class?

    I keep on getting this error when I try to run some VBA code that a former employee wrote, I can't seem to find what the issue is but this is where it stops running. It stops at ActiveCell.PageBreak = xlPageBreakManual, can someone please point me in the right direction to try and figuring this...
  3. C

    Prevent Display of PageBreaks before opening a Workbook - VBA

    Hi all, I have 300 spreadsheets that have 10 worksheets, each opening on PageBreak view. This slows down the opening of each spreadsheet. From ~42 seconds when displayed to 3 or 4 seconds without. This slows down my VBA code by a similar factor. I'm trying to figure out how to disable this in...
  4. Roderick_E

    Find out Pagebreak width and height on sheet

    I'm trying to fit some charts within a pagebreak. I've done it manually and it works fine but now I've found users changing the width of columns and rows (I don't want to protect sheet), so it mess up my manual settings. I'd like to determine the width and height of the first pagebreak (all...
  5. B

    Hide 2nd pagebreak VBA

    Hi Guys, I have page breaks in every excel sheet (Page 1,Page 2) set for printing purposes. What I would like to do is hide the 2nd page in each sheet and keep the 1st page. I need this to be active for all sheets except sheet named "Other" This is my code: For Each ws in...
  6. C

    Macro to insert 5 blank lines after a change in row A, copy the values in cells A, B, and C and the format from the entire row before insertion, and t

    I am looking for a macro to insert 5 blank rows at each change in Column A. Then I need it to copy the values from Col A, B, and C and the format from the entire row into those blank lines from the last row before insertion. After all that I need a page break inserted. I have been able to find...
  7. S

    vba code: save each hpagebreak as pdf with cell.value filename

    i have a sheet with horizontal pagebreaks set correctly, i want to save each pagebreak as separate pdf file, and name of file be the text in first cell on each page. i know how to save page as pdf, i need to know how to print at each horizontal pagebreak, and how to select first cell after each...
  8. H

    enable pagebreak arrowhead

    Pl help with this little problem. I can not adjust the page breaks by clicking and dragging them with mouse. Somehow it has been disabled. I can not drag the blue lines in order to change the position of lines in the pagebreak mode of view the worksheet. The arrow just does not appear when i...

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