Macro error - Cannot see mistake

Hi Experts Using Excel 2013

Cannot see the error here...

Range("A2:A" & LastRow).Formula = "=IF(IFERROR(OFFSET(Data!DQ84,MATCH(B84,Data!$DP$2:$DP$2000,0),-82),"")=0,A2)),"""")"

Open in new window

route217Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Máté FarkasConnect With a Mentor Database Developer and AdministratorCommented:
You always have to use double quotes in code:
Range("A2:A" & LastRow).Formula = "=IF(IFERROR(OFFSET(Data!DQ84,MATCH(B84,Data!$DP$2:$DP$2000,0),-82),"""")=0,A2, """")"

Open in new window

0
 
route217Author Commented:
thanks for the feedback
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.