Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VSTO column insert shift to right
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert row/column error "Cannot shift object off sheet" | Excel Discussion (Misc queries) | |||
can't insert a column, can't shift columns off the sheet. | Excel Discussion (Misc queries) | |||
I want to align two columns by using insert/shift down | Excel Worksheet Functions | |||
Finding the last nonblank cell in a column in VBA or VSTO | Excel Programming | |||
expression.Insert(Shift, CopyOrigin) ? | Excel Programming |