VBA Code vs Macro Recording code

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")

Please Login or Register  to view this content.

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

Originally Posted by 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

Please Login or Register  to view this content.

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

Hi,

code

Please Login or Register  to view this content.

works ok - did you test the range correctly?

shouldn't 'With Sheets' use .Range?

---