pagebreak

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...

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...

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...

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...

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...

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...

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...

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...