Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

Hi Siti, Thanks for your reply, But the below said is not working Below is the recorded code for removing pagebreaks ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 is any other code to remove page breaks *I need to set the Page break to end of the used last column.* *

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

I think, removing VPageBreaks and HPageBreaks can be done by setting FitToPage /Wide/Tall properties to : 1 Sub ClearPgBreasks() With ActiveSheet.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With End Sub On May 12, 8:33 pm, Sundarvelan N wrote: >

$$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

Hello Friends, Can anyone help me to remove Page Breaks in Excel sheets Using VBA code. Thanks, N.Sundarvelan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://t