Basic find and replace macro for commas and semicolons

[Jacc]

Why won't this macro work? I'm clueless...

Please Login or Register  to view this content.

Yes it's for converting those comas in formulas to semicolons which is the standard where I live.

[Jakobshavn]

How about:

Please Login or Register  to view this content.

[Jacc]

Oops! I almost forgot about this one, sorry!
Thanks for your reply, Jakobshavn! However, this does not work. Maybe it's because the commas needs to be replaced before Excel registers it as a formula. Kind of a catch 22!
I tried modifying it back and forth but no way no how did I get it to work.

[Jakobshavn]

To avoid the "Catch 22":

1. first change all the formulas to text
2. second edit the resulting "text" formulas
3. third convert the text back to formula

[Jacc]

I guess that would work but I'm still hoping for a one click solution.
So far I have been using the Ctrl + h to bring up the Search and Replace dialogue box, any solution would have to be easier than that.

What I don't understand is why my first piece of code doesn't work. The macro runs, no errors, but nothing happens... weird.

[Jacc]

Bump this.