Help with calling a function

I have a spreadsheet:

A1 = "Year"
A2 down through A150 has values 1900 through 2050.

AB1 = "Thanksgiving"

I have written a custom function in a module called "Thanksgiving" and
it takes a year as the parameter.

If I'm in cell AB2, how can I call this function using the values in
AB1 and A2 to get the result. I know I can type in
=THANKSGIVING($AB$1, $A2) but I'd rather build the function call based
on the values already in my spreadsheet.

I've tried building a literal expression, but cannot get Excel to
evaluate it:

="="&AB1&"("&A2&")"

Any ideas? Thanks!

I made a typo... The paragraph that starts "If I'm in cell AB2..."
should read:

If I'm in cell AB2, how can I call this function using the values in
AB1 and A2 to get the result. I know I can type in
=THANKSGIVING($A2) but I'd rather build the function call based
on the values already in my spreadsheet.

Sorry. Still looking for suggestions. Thank you.

Same answer.

--
Regards,
Tom Ogilvy


"CR" wrote:

> I made a typo... The paragraph that starts "If I'm in cell AB2..."
> should read:
>
> If I'm in cell AB2, how can I call this function using the values in
> AB1 and A2 to get the result. I know I can type in
> =THANKSGIVING($A2) but I'd rather build the function call based
> on the values already in my spreadsheet.
>
> Sorry. Still looking for suggestions. Thank you.
>
>

There is no built in support for having a variable function name.

I think you would need to use an if statement

=if(AB1="Thanksgiving",Thanksgiving(A2),if(AB1="LaborDay",LaborDay(A2),""))

An alternative is to create a function named Holiday which takes the name of
the holiday as one of the arguments.

--
Regards,
Tom Ogilvy


"CR" wrote:

> I have a spreadsheet:
>
> A1 = "Year"
> A2 down through A150 has values 1900 through 2050.
>
> AB1 = "Thanksgiving"
>
> I have written a custom function in a module called "Thanksgiving" and
> it takes a year as the parameter.
>
> If I'm in cell AB2, how can I call this function using the values in
> AB1 and A2 to get the result. I know I can type in
> =THANKSGIVING($AB$1, $A2) but I'd rather build the function call based
> on the values already in my spreadsheet.
>
> I've tried building a literal expression, but cannot get Excel to
> evaluate it:
>
> ="="&AB1&"("&A2&")"
>
> Any ideas? Thanks!
>
>

Thank you for the speedy reply. I guess that's one of many reasons why
Excel is such a piece of crap. Have a great day.

You could always role your own function that will operate this way using the
Evaluate command.

--
Regards,
Tom Ogilvy


"CR" wrote:

> Thank you for the speedy reply. I guess that's one of many reasons why
> Excel is such a piece of crap. Have a great day.
>
>