ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Page Breake to left (https://www.excelbanter.com/excel-programming/396936-page-breake-left.html)

ALEX

Page Breake to left
 
Hi All,

I'm inserting a first column and I want to adjust the left page breake to
the very left side but it gives me out of range error:

Worksheets(i).PageSetup.Orientation = 2
Worksheets(i).Columns(1).Insert Shift:=-4161
Worksheets(i).VPageBreaks(1).DragOff Direction:=-4159, RegionIndex:=1 ' the
error is here

Could anybody help me on it?

Thanks


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com