Show a named range within a label (not VBA)
 

I have a sheet that has a column value which states "Expenses in working
currency".
I would like to have it say "Expenses in USD" or "Expenses in MXP"
(whatever the currency is).
I have a named range in another sheet, ProjectInformation, that holds the
working currency value.
Not in VBA, but in the sheet I need to say something like: ="Expenses in" &
(ProjectInformation!C9) but this gives me an error.

Help, please.

Thanks.

Rick

Show a named range within a label (not VBA)
 

If I understand your set up correctly, try it this way...

="Expenses in "&ProjectInformation

--
Rick (MVP - Excel)


"rick" wrote in message
...
I have a sheet that has a column value which states "Expenses in working
currency".
I would like to have it say "Expenses in USD" or "Expenses in MXP"
(whatever the currency is).
I have a named range in another sheet, ProjectInformation, that holds the
working currency value.
Not in VBA, but in the sheet I need to say something like: ="Expenses in"
& (ProjectInformation!C9) but this gives me an error.

Help, please.

Thanks.

Rick