Delete Table Rows Based on Specific Text

Ah.

The whole row can't be deleted then, obviously. But you can delete just the data (the total figures) in the table, I think. How many columns is your GroupAuxDaily table? If it's located in columns A through G, for example, then something like this should work:

For Row = 1 To 100    '<-----  change the 100 as needed
  If Cells(Row, "G") = "Totals" Then
      Cells(row, "A") = ""
      Cells(row, "B") = ""
      Cells(row, "C") = ""
      Cells(row, "D") = ""
      Cells(row, "E") = ""
      Cells(row, "F") = ""
      Cells(row, "G") = ""
  End If
Next

You can also put that in a loop, of course:

For row = 1 To 100       '<-----  change the 100 as needed
  If Cells(row, "G") = "Totals" Then
      for column = 1 to 7
         Cells(row, column) = ""
      next column  
  End If
Next row