This replace only seems to work when it mataches an entire cell value, but i simply want to replace specific characters, like ', or ) or (, located withing cells, anywhere on the sheet, it doesn't replace.

    Set rng = ActiveSheet.UsedRange
    rng.Replace what:="(", replacement:=""
    rng.Replace what:=")", replacement:="-"

Any ideas?