Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to vba
i put this formula to vba
=CONCATENATE("Text", C2) VBA Cells(2, 1).Formula = "=CONCATENATE("Text", C2)" how to deal with the double quote with text? thanks a lot. tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to vba
Use the ascii code for a double quote: Cells(2, 1).Formula = "=CONCATENATE(" & Chr(34) & "Text" & Chr(34) & ", C2)" "tony wong" schreef in bericht ... i put this formula to vba =CONCATENATE("Text", C2) VBA Cells(2, 1).Formula = "=CONCATENATE("Text", C2)" how to deal with the double quote with text? thanks a lot. tony |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to vba
What moon gave you will work but it seems easier to use:
ActiveSheet.Cells(2,1).Formula = "=CONCATENATE(""Text"",C2)" "tony wong" wrote: i put this formula to vba =CONCATENATE("Text", C2) VBA Cells(2, 1).Formula = "=CONCATENATE("Text", C2)" how to deal with the double quote with text? thanks a lot. tony |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to vba
Cells(2, 1).Formula = "=CONCATENATE(""Text"", C2)"
-- Regards, Tom Ogilvy "tony wong" wrote in message ... i put this formula to vba =CONCATENATE("Text", C2) VBA Cells(2, 1).Formula = "=CONCATENATE("Text", C2)" how to deal with the double quote with text? thanks a lot. tony |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to vba
"JLGWhiz" schreef in bericht ... What moon gave you will work but it seems easier to use: ActiveSheet.Cells(2,1).Formula = "=CONCATENATE(""Text"",C2)" I never understood the need of =CONCATENATE anyway, since strings can easily be concatenated with the &: ActiveSheet.Cells(2,1).Value = "Text" & ActiveSheet.Cells(2,3).Value |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to vba
Thanks a lot.
they work to me. "Tom Ogilvy" .gbl... Cells(2, 1).Formula = "=CONCATENATE(""Text"", C2)" -- Regards, Tom Ogilvy "tony wong" wrote in message ... i put this formula to vba =CONCATENATE("Text", C2) VBA Cells(2, 1).Formula = "=CONCATENATE("Text", C2)" how to deal with the double quote with text? thanks a lot. tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
How to convert a static formula to dynamic formula ? | Excel Worksheet Functions | |||
Excell convert formula row to formula column | Excel Worksheet Functions | |||
how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
Convert Normal formula to array formula | Excel Programming |