VSTO column insert shift to right
Yes, here it is:
Excel.XlInsertShiftDirection.xlShiftToRight
Seek and ye shall find.
--
Bob Sullentrup
"Bob Sullentrup" wrote:
Folks,
What's the syntax for inserting a column and shifting cells to the right?
This is close but no cigar:
((Excel.Range)rng.Cells[1,c]).EntireColumn.Insert(Shift.xlRight,Type.Missing);
the Shift.xlRight is incorrect.
--
Bob Sullentrup
|