Hello Friends,
I am using this formula in a VBA code
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
I am using this formula in a VBA code
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