This should do it.

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


-----Original Message-----
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




.