I've been trying to write a dynamic address into a cell as input to a formula. Unfortunately usage of a concatenated string (variable ftext) returns
=IF(ISBLANK(F8);Master!'A2';0) instead of =IF(ISBLANK(F8);Master!A2;0)
i. e. it's not interpreted as a cell reference (resulting in #NAME? instead of the value in Master!A2). Would appreciate any thoughts that might help.
Code excerpt
...
...Please Login or Register to view this content.
Bookmarks