Inserting a formula with strings into cell

[ParanoidAndroid]

Hi Guys

I'm trying to write a formula to be pasted into a cell with VBA but the " " appear to be causing problems?

ive tried a few variations on below with both " and ' - no luck

Sheets("Hot").Range("L2").Range = "=IF(ISERROR(MATCH(K2,MO_Linked!V:V,0)),"Hello","goodbye")"

Sheets("Markets").Range("L2").Formstring = "=IF(ISERROR(MATCH(K2,MO_Linked!V:V,0)),'Hello','Goodbye')"

Anyone able to advise? Much appreciated if you can

 

[VoG]

Try

Sheets("Hot").Range("L2").Formula = "=IF(ISERROR(MATCH(K2,MO_Linked!V:V,0)),""Hello"",""goodbye"")"

 

[ParanoidAndroid]

Still not working

Says subscript out of range

Sheets("Hot").Range("L2").Formula = "=IF(ISERROR(MATCH(K2,MO_Linked!V:V,0)),""Hello"",""Googbye"")"

 

[VoG]

Check that the sheet is actually called "Hot", not " Hot" or "Hot " etc.