VBA Will Not Accept Vlookup Formula that Works in Sheet

[CatLadee]

Any ideas why this formula won't work in VBA but will in the worksheet? The responses tab exists. How should it be updated? THANK YOU!

    ActiveCell = "=IF(VLOOKUP(E2,Responses!E:R,8,FALSE)=0,"",(VLOOKUP(E2,Responses!E:R,6,FALSE)))"
    Range("J2").Select

 

[JoeMo]

Any ideas why this formula won't work in VBA but will in the worksheet? The responses tab exists. How should it be updated? THANK YOU!

    ActiveCell = "=IF(VLOOKUP(E2,Responses!E:R,8,FALSE)=0,[B][COLOR=#ff0000]""""[/COLOR][/B],(VLOOKUP(E2,Responses!E:R,6,FALSE)))"
    Range("J2").Select

Double the quote marks (Bold Red above) so VBA recognizes them as part of a string.

 

[CatLadee]

Thanks a bunch, Joe! I appreciate your help!