>Celtin !
>
>Thanks for your response. I had tried that before and even now but to no avail.
>Mine goes like ;
>
>"loxls.ActiveWorkbook.ActiveSheet.VPageBreaks(1).DragOff(xlToRight,1)"
>
>I also tried;
>
>"loxls.ActiveWorkbook.ActiveSheet.VPageBreaks(1).DragOff(-4161,1)"
>
>I have included the Excel header file via #INCLUDE EXCEL9.H at the begining of the procedure that runs this code. I use Office 2000.
>
>The Ole Error Code is 0x800a03ec (Unknown COM status Code)
>
>However, typing Obj=loxls.ActiveWorkbook.ActiveSheet.VPageBreaks(1) at the error level results in an Oject variable
>
>Did it work at your end ? if you haven't tried it, please do and give me the feedback
>
>Fred Matano
Yes it works here. Probably you didn't switch view.
PS: I don't know what would be the benefit of this command for you. I'd instead use:
with oXL.ActiveWorkBook.ActiveSheet
.VPageBreaks(nIndex).Location = .RAnge('K1')
endwith
Cetin