how to delete column

[tuarek]

Hi,

How can one delete a column and left shift the following columns?

I tried following but it fails.

myspreadsheetobject.ActiveSheet.Columns("a:a").delete(myspreadsheetobject.constants.XlDeleteShiftDirection.xlShiftToLeft);

What am i doing wrong?

Thanks in advance...

 

[tuarek]

I also tried

myspreadsheetobject.ActiveSheet.Columns("a:a").delete(-4159);

but the result hasn't changed... It still fails...