Give this a try. It searches columns A, B and C for the word 'Total' to determine what I think you mean by "the subtotal column". The code does not have error checking to see if the word Total occurs in more than 1 of the checked columns. If you need to check more columns, adjust the "For i = 1 to 3" line
Also, I wasn't sure what you wanted to do with the "Grand Total" line. Code may need adjustment to deal with that?