Hi all,
I recorde a macro to replace my commas in amount with dots.
Columns("AB:AB").Select
    Selection.Replace What:=",", Replacement:=".", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
Works manually while recording it ok.
But when I run the recorded macro it will not replace anything....