Replacing . by , in script

Copper Contributor

I encounter some problems in replacing a . by a ,

I want to record a macro, but it automatically substitutes the , by a "

Is there a workaround?

1 Reply

@Jan_Moonen 

In a macro, you can use code such as

    Range("A2:A100").Replace What:=".", Replacement:=",", LookAt:=xlPart