.formula error

[dappy]

Hi folks,

Peter SSs kindly gave me this formula yesterday which works perfectly when insterted to a cell however put into vba i get a runtime error. Am i doing something wrong? is there something missing?

this is correct though right?

Range("D2").Formula = "=IFERROR(INDEX($A$2:$A$100,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$100)+(A$2:A$100=""),0),0)),"")"

thanks again in advance

Carl

 

[RoryA]

No, you need to double any quotes inside the formula string like this:

Range("D2").Formula = "=IFERROR(INDEX($A$2:$A$100,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$100)+(A$2:A$100=""""),0),0)),"""")"

 

[dappy]

No, you need to double any quotes inside the formula string like this:

Range("D2").Formula = "=IFERROR(INDEX($A$2:$A$100,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$100)+(A$2:A$100=""""),0),0)),"""")"

Seriously, you folks are amazing. thanks so much for this, its a world of white noise for me and you've saved my mind!

thanks RoryA, that's fantastic, i'm so grateful

Carl

 

[RoryA]

Glad to help. It does get easier, trust me!