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.
Windows11 Pro 64 bit
Excel Professional Plus 2019
Excel Professional Plus 2019
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.
Ok I will try that. For now it's weekend 🙂