Jun 7, 2007 #1 alwayslrN IS-IT--Management Jun 20, 2006 159 US I am using Excel 2002 SP3. I was wondering if the following could be done in Excel. A5 = ABCD a tab is named ABCD there is a formula that looks like =ABCD!$E$17 I want to be able to build the forumula using the value from A5. Is that possible?
I am using Excel 2002 SP3. I was wondering if the following could be done in Excel. A5 = ABCD a tab is named ABCD there is a formula that looks like =ABCD!$E$17 I want to be able to build the forumula using the value from A5. Is that possible?
Jun 7, 2007 #2 PHV MIS Nov 8, 2002 53,708 FR What about the INDIRECT function ? Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Jun 7, 2007 Thread starter #3 alwayslrN IS-IT--Management Jun 20, 2006 159 US Hi PH I forgot to mention that A5 is in a different worksheet than worksheet ABCD Upvote 0 Downvote
Jun 7, 2007 #4 PHV MIS Nov 8, 2002 53,708 FR As you asked in the VBA forum, a VBA suggestion: SomeRange.Formula = "=" & SomeSheet.Range("A5") & "!$E$17" Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
As you asked in the VBA forum, a VBA suggestion: SomeRange.Formula = "=" & SomeSheet.Range("A5") & "!$E$17" Hope This Helps, PH. FAQ219-2884 FAQ181-2886
Jun 7, 2007 #5 yogia Technical User Mar 5, 2004 328 US Hi alwayslrN: I had a little play with it and using the setup proposed by PHV, the following worked for me ... Code: someRange.formula="=indirect(A5&""!E17"")" Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC http://www.energyefficientbuild.com Upvote 0 Downvote
Hi alwayslrN: I had a little play with it and using the setup proposed by PHV, the following worked for me ... Code: someRange.formula="=indirect(A5&""!E17"")" Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC http://www.energyefficientbuild.com