Seeing as I was helped so well with my last problem, I'd appreciate a hand with this one too.

I have a table of various bits of information and the last column in the table has the "owner" of that information in it. In order to highlight where one batch of rows of the same owner stops and another begins I want to have the border line separating those two rows in red, rather than black. Bearing in mind that when I turn some filters on this has an affect on which borders show up. Just because the red line appears separating the owners on the global table, does not mean that it appears in the filtered table if that particular row is filtered out.

Is there some way to have the code ignore rows hidden by a filter? I have come across the subtotal function, but that is for adding up values in non-hidden columns.