Hi,

Im trying to colour code my Subtotal rows as part of my macro.
I want to search the sheet and colour it red if its a subtotal.

I tried the following but it ignored the Grand Total Row.

Is there a way to say "If its a subtotal type of data colour it red"?

Thanks

Here is my code for the grand total that does not work.

For Rowdates2 = Range("A1").End(xlDown).Row To 1 Step -2

If Cells(Rowdates2, "A").Value = "Grand Total" Then

Rows(Rowdates2).Interior.ColorIndex = "5"

Else


End I

--
Message posted from http://www.ExcelForum.com