| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Learning Excel | New Users to Excel | |||
| Learning Excel | New Users to Excel | |||
| Learning VB for Excel | New Users to Excel | |||
| Learning excel | Charts and Charting in Excel | |||
| Learning how to use Excel | Excel Discussion (Misc queries) | |||
Linear Mode
