Thread: convert formula to vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony wong tony wong is offline
external usenet poster
  
Posts: 14
Default 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


Reply With QuoteReply With Quote