Forum Discussion
Solved
I have couple formulas. I want hard code into vba
I have worksheet called PTW1 and I also have other worksheet called 1 In cell D2 have this formula =IF('1'!D2<>"",'1'!D2,"BWT") =IF('1'...
function INDIRECT()
=IF(INDIRECT("'1'!D2")<>"",INDIRECT("'1'!D2"),"BWT")=IF(INDIRECT("'1'!G2")<>"",INDIRECT("'1'!G2"),"BWT")
That I do for G2?
Thanks You
function INDIRECT()
=IF(INDIRECT("'1'!D2")<>"",INDIRECT("'1'!D2"),"BWT")
=IF(INDIRECT("'1'!G2")<>"",INDIRECT("'1'!G2"),"BWT")
That I do for G2?
Thanks You
yes that is what I'm suggesting and it appears that it is working? Glad it helped.
The function doesn't work it is in red can check wrong. if possible can send copy of file
Thanks You
sf49ers19238597 works for me (see attached).