Learning Excel VBA
 

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

Learning Excel VBA
 

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

Learning Excel VBA
 

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

Learning Excel VBA
 

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

Learning Excel VBA
 

Correction. Your first one does not work


--
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

Learning Excel VBA
 

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

Learning Excel VBA
 

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

Learning Excel VBA
 

Always helps to try to explain what you mean in the original post.

Range("MF") = Range("frm1").Formula

--
Don Guillett
SalesAid Software

"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

Learning Excel VBA
 

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