Is it possible it does not like the Range within the MID? Try breaking itinto three statementsTmpstr = Range("E3")Mid(Tmpstr), 20, 3) = "IKL"Range("E3" = Tmpstr