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.…...Product Family cells-net flotoz July 26, 2024, 5:15pm 1 Hello, I...Test_V1.1.zip (14,2 Ko) amjad.sahi July 26, 2024, 8:07pm 2 @flotoz ...