How to add a column in C# ?

[ubsman]

Anyone know the code to add a column using C#. If not then I'll take some VBA code. What I tried there below did not work.

rangeXX = ws.get_Range("Q1", "Q1").EntireColumn;
rangeXX.Select();
ws.Columns.Insert(Excel.XlInsertShiftDirection.xlShiftToRight,
Type.Missing); // cannot shift items off sheet

[shg]

Please edit your post to add code tags.

[ubsman]

OK, if you want to tell me what a "code tag" is.

[Leith Ross]

Hello ubsman,

Please read the forum rules. It will explain how to add the code tags. Why are you posting a question about C# in an Excel VBA Forum? Microsoft has C# news groups.