Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Sep 23, 2021
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'...
excel
Formulas and Functions
Macros and VBA
  • sf49ers19238597's avatar
    sf49ers19238597
    Sep 23, 2021

    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

mtarler's avatar
mtarler
Silver Contributor
Sep 23, 2021
yes that is what I'm suggesting and it appears that it is working? Glad it helped.
    • sf49ers19238597's avatar
      sf49ers19238597
      Iron Contributor
      Sep 24, 2021

      mtarler 

       

      I delete worksheet called 1 in PTW1 still saying #REF on your file you  posted

       

       

      Thanks You

      • mtarler's avatar
        mtarler
        Silver Contributor
        Sep 24, 2021
        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?

Resources