View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default 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