MarkitRTD cell formula in VB

[AussieRob]

Guys - trying to set up a sheet to link to an external data source (MarkIt). Cell formula is =MarkitRTD($A5,J$4,"QUOTES",,,,$C$1)

Trying to put it into VB but I can't use: cells(5,10)="=MarkitRTD($A5,J$4,"QUOTES",,,,$C$1)"

because of the "QUOTES". Tried xxx = ""QUOTES"" but thats no good either.

thanks for your help.


rob

 

[VoG]

I have no way of testing this but try

Cells(5, 10) = "=MarkitRTD($A5,J$4,""QUOTES"",,,,$C$1)"