Macro deleting commas

Hey,

I have a workbook with a macro which grabs worksheets and saves them as there own individual workbooks on my desktop, as CSV files. is it possible to have a macro and go into each individual cell and delete all commas in the text before i run this macro? reason is i then import these CSV files into my access DB and the commas seperate the fields. so if the text has commas in it then it doesnt seperate the fiedls properly, thanks in advance!!!

Adding to Richard's suggestion perhaps a macro like this?

Please Login or Register  to view this content.

Alf

Alf,

how would i constrict this to just row 2? thanks,

Perhaps like this?

Please Login or Register  to view this content.

Alf

that didnt work either, i have been trying to play around with the too pieces here, this is what i have but when i run it, nothing actually happens.

Please Login or Register  to view this content.

Strange as it works ok for me.

To test file run macro "rem_comm_row". This will remove all commas from row 2

Macro "remove_comma" will remove all commas from Sheet1

Alf

i got it to work, i removed the dim cell as Range,

Please Login or Register  to view this content.

thanks alf!