Then the reason it doesnt' work is that your formula is written with a
semicolon and the formula method is looking for a comma.

Range("MF").Formula = "=" & Replace(Range("FRM1").Text,";",",")

should work.

Formulas entered through VBA using the formula property should use US
English conventions.

--
Regards,
Tom Ogilvy


"Maurizio" wrote in message
...
Perhaps I didn't explain it clearly.
FRM1 is a named cell that contains something (inserted from previous macro
coding) like

LEFT(A43;5)

I need to assign it as a formula to all the cells of range MF that should
contain

=LEFT(A43,5)
Maurizio

"Tom Ogilvy" wrote:

Assuming Range("FRM1") contains the string ABC.

You want to produce something like

="ABC"

as written you produce

=ABC

Which makes excel look for a defined name ABC.
try

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


--
Regards,
Tom Ogilvy


"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