- Sep 7, 2018
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