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
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).
- Did you create a new sheet called 1? Maybe I misunderstood your intentions. I thought you have these formulas that refer to a sheet called "1" but you delete that sheet and create a new sheet that is named "1" and you need those formulas to still work and now use this new sheet "1"? Am i mistaken?
Thanks You for formulas It is working now.