Maybe try:

Sub baby_kay_2003yy()
Dim ws As Worksheet
Dim fCell As Range

Set ws = ActiveSheet
Sheets.Add.Name = "Our Chargebacks"

With ws
For Each fCell In .Range("A2:A" & .Range("A" & Rows.Count).End(3).Row)
If fCell.Interior.ColorIndex = 6 Then .Rows(fCell.Row).Copy Sheets("Our Chargebacks").Range("A" & Rows.Count).End(3)(2)
Next fCell
End With
End sub