| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
