| 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
"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 |
|
#5
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 |
|
#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 | |||
Hybrid Mode
