Thread: convert formula to vba
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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



Reply With QuoteReply With Quote