page break preview

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

Sub Macro1() ' ' Macro1 Macro ' ' ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 End Sub I have recorded a macro to drag off the direction of page break to right, I have 30+ sheets and I want that the code to run over all sheets except sheet name "Count" & "Raw...

Hello, I am trying to use a macro button that allows the user to set the page breaks. The goal would be to have the button work as listed below... If ActiveSheet is in PageBreakPreview mode, then switch back to normal mode If ActiveSheet is in Normal mode, then switch to PageBreakPreview As...

Hi, I am having an issue with an Excel tool we are using to produce reports. The report is a series of pages in an Excel worksheet. The users asked me to add in the ability to choose which pages are printed off, so I wrote a macro that would copy everything to a new sheet, delete superfluous...

I have just switched to Excel 2010, and I am trying to set up a worksheet to print on 2 pages. I have created this file in Excel 2010, so it is not a conversion from an earlier version of Excel. This is a simple task that I have successfully accomplished, oh, 2,659,393,101 times before (give...

Hey everybody! We recently converted to Office 2007 at work, and I'm struggling through the change! One thing that I've noticed in Excel 2007 (which doesn't happen to one of my coworkers) is that if my "Normal View" is zoomed (e.g. 75%, 150%) and I change to "Page Break Preview" view then back...