All of these, including the one you said didn't work, do work the same and
the last one will leave the formula instead of the value.

Sub vbaunderstand()
Range("mf") = ""
'Range("MF").Formula = "=" & Range("FRM1").Text
'Range("MF").Formula = Range("FRM1").Text

'Range("mf") = Range("frm1") 'simplest

Range("MF").Formula = "=FRM1" 'leave formula
end sub
--
Don Guillett
SalesAid Software

"Maurizio" wrote in message
...
Please, would someone help me understand VBA?
What' wrong in the following statement:?

Range("MF").Formula = "=" & Range("FRM1").Text

the foloowing works correctly:

Range("MF").Formula = Range("FRM1").Text

Thanks for your time. Maurizio