How to delete a row on an excel spreadsheet using C#

See more:

C#

.NET

Visual-Studio

I managed to get the range working correctly to include the whole row, but deleting the row fails. It does not produce an error; it just does not delete the row. Finding the empty row works fine, and I placed a marker several rows below the empty row. The result is the empty row is not getting deleted. The sheet is not protected.

The code is:

private void cmdEnterData_Click(object sender, EventArgs e)
   {
      bool found = false;
      int intRowIndex;

      string targetSheetName = txtDate.Text.Substring(0, 3);
      // Add the current year to the name 
      //which gives the full name of the sheet
      targetSheetName = targetSheetName + " " + DateTime.Now.Year.ToString();
      // Get the worksheet
      Excel.Worksheet targetWorksheet =
      (Excel.Worksheet)frmFoodPantry.theWorkbook.Worksheets[targetSheetName];
      targetWorksheet.Activate();
      // Find the first empty row using the sheet index number
      int emptyRow = frmFoodPantry.FindEmptyRow
      (RegGlobals.StartingRow, targetWorksheet.Index, RegGlobals.dateCol);
            
     for(intRowIndex = RegGlobals.StartingRow; 
         intRowIndex < emptyRow && !found; intRowIndex++)
    {
       DateTime dtSheetDate = targetWorksheet.Cells[intRowIndex, RegGlobals.intDateCol].Value;
      if (DateTime.Parse(txtDate.Text) < dtSheetDate)
      {
         Excel.Range rngRow = frmFoodPantry.theWorkbook.ActiveSheet.Range[RegGlobals.dateCol + emptyRow.ToString()].EntireRow;

        // For debugging
        string temp1 = rngRow.Address;

       rngRow.EntireRow.Delete(XlDeleteShiftDirection.xlShiftUp);

       // Saving the file for debugging
       frmFoodPantry.objApp.DisplayAlerts = false;
       frmFoodPantry.theWorkbook.Save();
       frmFoodPantry.objApp.DisplayAlerts = true;

       targetWorksheet.Rows.Insert(intRowIndex,1);
       found = true;
     }
   }
   LoadData(intRowIndex, targetSheetName);
   if (EditsMade)
   {
      frmFoodPantry.objApp.DisplayAlerts = false;
      frmFoodPantry.theWorkbook.Save();
      frmFoodPantry.objApp.DisplayAlerts = true;
      EditsMade = false;
   }
}

What I have tried:

targetWorksheet.Cells.Delete(rngRow); (will freeze running)
rngRow.EntireRow.Delete(XlDeleteShiftDirection.xlShiftUp);
((Range)rngRow.Rows[emptyRow]).Delete();
rngRow.Rows.Delete(XlDeleteShiftDirection.xlShiftUp);
rngRow.Delete(XlDeleteShiftDirection.xlShiftUp);