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