Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert data in multiple rows
Hello all
as per the code below, its reading 4 rows and i want all the four rows to be inserted in new row of excel. Kindly help me to achieve the same if (srcRng1.Value2.ToString() == "Affected Products:") { for (int j = i; j <= i + 1; j++) { //Excel.Range range = (Excel.Range) excel.Cells.get_Item(i, j); //range.Insert (Excel.XlInsertShiftDirection.xlShiftDown, System.Type.Missing); TempAP = _shtSrc.get_Range("B" + j.ToString (), Type.Missing); destRng1.Insert (Excel.XlInsertShiftDirection.xlShiftDown, Type.Missing); destRng1.Value2 = TempAP.Value2; } } Thanks Shantanu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert multiple rows | Excel Discussion (Misc queries) | |||
Insert Multiple rows with data | Excel Programming | |||
how do insert multiple rows in between multiple lines | Excel Discussion (Misc queries) | |||
Insert Multiple Rows | Excel Discussion (Misc queries) | |||
how do I insert multiple rows in excel after every row of data | Excel Discussion (Misc queries) |