Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Little_Yellow_Duck: Feb 16, 2002; Who wears short shorts

Is there a simple excel function to evaluate a text string as a function? Here's a possible example sheet:

pre:

Sheet To Evaluate     Cell To Evaluate   Result
Sheet2                A1                 =EvalStr("='" & T(A2) & "'!" & T(B2))
Sheet7                D4                 =EvalStr("='" & T(A3) & "'!" & T(B3))

so the Result column would return the same as if it were filled with ='Sheet2'!A1 , ='Sheet7'!D4 .

Edit: Looks like I'll have to read up on VB Script. From this pcreview forum:

code:

Function myFunct(InputString)
Application.Volatile
myFunct = Application.Evaluate("=" & InputString)
End Function

Little_Yellow_Duck fucked around with this message at 20:35 on Nov 23, 2009

# ¿ Nov 23, 2009 19:58

Adbot: ADBOT LOVES YOU

# ¿ Apr 27, 2024 15:40

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread