I'm not quite sure if I understand your question correctly. However, when usingx = Range("d1").Formulayou get the formula in cell D1 rather than the value.Does this help?,