Forum Discussion
Solved
calling a dynamic range by composing the name with text and cell.value
Hi there, office Professional Plus 2019 I'am trying to call a defined dynamic range bij composing its name from text and cell.value something like : = sum(indirect("Eigen_"& N43). The dynamic...
Okay, you have no dynamic arrays. If with VBA you may try something like using INDIRECT function with dynamic array formula syntax (Excel O365) - Stack Overflow, didn't test it. Or create helper ranges with OFFSET(), name them and use in INDIRECT.
Could you please specify more concretely in which sheet and cell formula doesn't work