I need to programmatically insert a column in the first column of an
Excel sheet. I tried using the code
wsSheet.Columns.EntireColumn.Insert(Excel.XlInsert ShiftDirection.xlShiftToRight);

and I even tried creating a range and shifting the range to the right
and then inserting a column, but that didn't work either.

Am really in need of help here.... please let me know if there is some
code i can use. And for some reason
oWSheet.Columns(1).Insert
doesn't work either.


--
rkappini
------------------------------------------------------------------------
rkappini's Profile: http://www.excelforum.com/member.php...o&userid=31216
View this thread: http://www.excelforum.com/showthread...hreadid=509322