VBA Code vs Macro Recording code

[JoeSharp]

Hi all, I have an excel spreadsheet that I would like to check for "," and replace with " ". I used a macro recording to get the code but when I enter this code with the rest of my VBA coding it does not work. The code does not come back in error it just steps through each line without making the changes I require. Below is the code

'Replace all commas with blanks in the text field.
With Sheets("Form")

 
        Range("R16:R1015").Select
        

            Selection.Replace What:=",", Replacement:=" ", LookAt:=xlPart, _
                searchOrder:=xlByRows, MatchCase:=False
            Range("R16").Select
            
            Sender = ActiveWorkbook.Sheets("Form").Cells(8, 18).Value

    End With

If anyone could come back with some suggests as to why this does not work then hat would help me out a great deal.

Many thanks

J