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.

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="La borDay",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!

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.

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.