<div>
Didn't occur to me that you had have it in PageBreak View.<br />
<br />
Thanks
</div>


Didn't occur to me that you had have it in PageBreak View.

Thanks

<div>
<div class="content wysiwyg-content">
Right now I have a workbook with several sheets in it. &nbsp;I run a macro that imports all data into the sheets and then highlights rows based on criteria, then it autoformats all the rows length. &nbsp; When this happens the Vertical Page Break gets set. &nbsp;I would like a way to either get rid of all the Vertical Page breaks on a sheet or how to set them all to the far right column.<br />
<br />
Excel gave me this code when I recorded a Macro but it doesn't work in my macro, it gives me Run-time Error 1004: &nbsp;<br />
ActiveSheet.VPageBreaks(1)<wbr />.DragOff Direction:=xlToRight, RegionIndex:=1
</div>
</div>


Right now I have a workbook with several sheets in it.  I run a macro that imports all data into the sheets and then highlights rows based on criteria, then it autoformats all the rows length.   When this happens the Vertical Page Break gets set.  I would like a way to either get rid of all the Vertical Page breaks on a sheet or how to set them all to the far right column.

Excel gave me this code when I recorded a Macro but it doesn't work in my macro, it gives me Run-time Error 1004:  
ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1

Setting the Vertical Page Break in an Excel Macro

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.