Is there a way to remove the default page breaks that excel puts in?
I've tried xls.ResetAllPageBreaks but it doesn't seem to work.
I've also tried
which is what a recorded macro told me to do. And i get an error (Subscript out of range)Code:xls.Activate ActiveWindow.View = xlPageBreakPreview ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
I appreciate any help.




Reply With Quote