Can a formula be created using values from a field?

[alwayslrN]

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?

 

[PHV]

What about the INDIRECT function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[alwayslrN]

Hi PH

I forgot to mention that A5 is in a different worksheet than worksheet ABCD

 

[PHV]

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

 

[yogia]

Hi alwayslrN:

I had a little play with it and using the setup proposed by PHV, the following worked for me ...

someRange.formula="=indirect(A5&""!E17"")"

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com