I'm able to add a new row from code (C#) but how can i add text to the new
row that was just added?
this is what i have:

currentCell = (Excel.Range)cellCars.Cells.get_Item(location+=1,1 );
Excel.Range dRow = currentCell.EntireRow;
dRow.Insert(Excel.XlInsertShiftDirection.xlShiftDo wn, missing);
dRow.Value2 = "Total Sales";

its not entering Total Sales to the new added row in Cell A#?

what do i need to add to add Total Sales to the correct A cell?