JosephP,
Again you save me! That works perfectly.

Can you explain the reasoning behind this line of code? I don't understand the reason for .Offset, though I can recognize offsetting -2, then adding 8 to row count ends up with 6 rows colored. 
With .Offset(-2, -1).Resize(.Rows.Count + 8, .Columns.Count + 2)