Array Function not working on Macro Enabled Excel

[travelfreakg2g]

Hello all

I am trying to use an array function in a Macro Enabled Excel, which was
working perfectly on a Normal Excel file, but is not working now.

Can you anyone explain why is this happening?

IFERROR(SUBSTITUTE(TEXTJOIN("",TRUE,IF(CODE(MID(V6,ROW(INDIRECT("$1:$"&LEN(V6))),1))=63,MID(V6,ROW(INDIRECT("$1:$"&LEN(V6))),1),"")),"?",""),"")


Thank you