VSTO column insert shift to right
When your inserting an entire column, you don't need to specify the shift
command.
--
Regards,
Tom Ogilvy
"Bob Sullentrup" wrote in message
...
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
|