View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tegger tegger is offline
external usenet poster
 
Posts: 16
Default double quotes around string in formula craeted in vba

I'm trying to enter this formula:

=Work!A4&"Fri Night"



with this line of code:

Worksheets(3).Cells(r, x).Value = "=Work!A" & r & "Fri Night"



I can't see how to get the double quotes around the Fri Night.



If anyone can help, I'd be most grateful,

DL