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