How about using indirect("K13") in place of $K$13. Since K13 is entered as text, it wont change.