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

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

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