page break setup

I want to copy many times a form on the same sheet where it is, it is curious, but they use it at work I think to homogenize the records and records. The example I have is to copy the form (first image) 50 times on the same sheet quickly and without having to go down all the way moving the page...

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

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

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

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

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