You probably want:

Range("MF") = Range("FRM1").Value


"merjet" wrote:

What' wrong in the following statement:?
Range("MF").Formula = "=" & Range("FRM1").Text

Assume the text is 'cow'. Then the formula is =cow, so Excel looks for
a function named 'cow' and can't find it.

Hth,
Merjet