Hello,
I am encountering an issue with the formula {=TEXTJOIN(“;”, TRUE, “'” & NAMEDRange & “'”)}. After calling the Cell.Calculate method, Cell.Value returns ‘#VALUE!’.
Here is an example of my excel file:
Test_V1.1.…...and concatenate with named range returns "#VALUE!" and works...