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