VBA - array formula not following relative cell reference

[hrayani]

Hello Friends,

I am using this formula in a VBA code

Range("G11:G483").FormulaArray = "=TEXTJOIN("", "",TRUE,UNIQUE(IF(orders_ref=B11,orders_article,"""")))"

But the problem is that cell B11 is treated as absolute reference - whereas I want it to be relative reference

Am I missing something here ??

Any help would be appreciated

Regards,

Humayun

 

[Norie]

Unfortunately, for some reason, that's what happens when entering array formulas into multiple cells directly using VBA.

This should fix things.

Range("G11").FormulaArray = "=TEXTJOIN("", "",TRUE,UNIQUE(IF(orders_ref=B11,orders_article,"""")))"
Range("G11").Copy Range("G12:G483")

 

[hrayani]

Hi Norie,

That did the trick...

Thanks & Regards,

Humayun