Find A Value In Column A And Then Make A Copy Of The Whole Row Right Below It

I have the text value "Ball, Red" somewhere in column A. I don't know which row it's in because it will never be in the same row twice. I need a macro to find this value, then, copy that whole row and "insert copied cells" right below that row and change the value in the newly created cell from "Ball, Red" to "Red, Ball".

I tried macro recorder to do this and had no luck...


Cells.Find(what:="Ball, Red", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Range("A21").Select
Selection.Insert Shift:=xlDown
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "Red, Ball"
Range("A22").Select
That's is all there is to it on this one.