I've made  one RefEdit, two text box,which the first text boxt express the
begining value, and the second textbox  is the upper value. I select a cell  with
RefEdit, and the I do For-Next procedure. And it's handled by a command button.
Sub CommandButton1_Click ()

For n = TextBox1.Value to TextBox2.Value
Range(RefEdit).Value = n
Next n
End If

But that procedure means replace the cell value  I've select, with inputed
value in textboxes, and also clears the formula  within cells. Is there any way
to keep the formula in the cell and the value we've inputed in the textbox just
change the value no the formula.