Guys,
i have a simple code:
The goal is to change the regional settings. I want to get rid of "," which means decimal places in my region.
Unfortunatelly this is not working
IN the cells there are just values with general format like 7,100. After macro it should be 7100.
I run Ctrl+H manualy and this is working. Once in macro - it doesn't
pls support
i have a simple code:
Code:
With Rows("3")
.Replace What:=",", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
End With

The goal is to change the regional settings. I want to get rid of "," which means decimal places in my region.
Unfortunatelly this is not working

IN the cells there are just values with general format like 7,100. After macro it should be 7100.
I run Ctrl+H manualy and this is working. Once in macro - it doesn't

pls support