IFERROR and IF Formula in VBA

Asked Aug 05 '19 at 21:29

Active Aug 05 '19 at 21:33

Viewed 35 times

I'm trying to put =IFERROR(IF(C$1>-1,INDEX(A:A,MATCH(A1,B:B,0)),""),0) in defined range G1:H10

Me.Range("G1:H10").Formula = "=IFERROR(IF(C$1>-1,INDEX(A:A,MATCH(A1,B:B,0)),""),0)"

The code doesn't work and I think it's because of IF and IFERROR
Any help how to fix it?
Thanks.

edited Aug 05 '19 at 21:33

Tim Williams

asked Aug 05 '19 at 21:29

ggmkp

1

Me.Range("G1:H10").Formula = "=IFERROR(IF(C$1>-1,INDEX(A:A,MATCH(A1,B:B,0)),""""),0)" – Tim Williams Aug 05 '19 at 21:33
Oh.. it's because of quotes... – ggmkp Aug 05 '19 at 21:36

0 Answers0