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.…...Formula with mixing TEXTJOIN and concatenate with named range...encountering an issue with the formula {=TEXTJOIN(“;”, TRUE, “'” &...