excel.interop insert a column in between existing columns

  • Thread starter Thread starter cupboy
  • Start date Start date
C

cupboy

Any example of how to do this? I tried this, but it does nothing....

rangeXX = ws.get_Range("Q1", "Q1");
rangeXX.Columns.EntireColumn.Insert(Excel.XlInsertShiftDirection.xlShiftToRight,
Type.Missing);
 
Any example of how to do this? I tried this, but it does nothing....

rangeXX = ws.get_Range("Q1", "Q1");
rangeXX.Columns.EntireColumn.Insert(Excel.XlInsertShiftDirection.xlShiftToRight,
Type.Missing);
Click to expand...

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.
 
Back
Top