I have cells with formulas like:
=sheet1!Y11+KS!Y8+sheet2!#ADR!+M12+P5+P21
In my specific case it is a sum only (a more general solution would be preferable)
When all cells are in the same sheet ie.:
=#ADR!+M12+P5+P21...
The following works OK, but is quite slow when there are couple hundred ranges to check.
I know how to force it to work for sheet2!#ADR! cases, but it would be even slower.Please Login or Register to view this content.
I have some ideas with other text functions...
But I bet there is a better way, like 5 lines of code
I would greatly appreciate even the vaguest hints. What is the smart way to do it?
Bookmarks