Variable names for named range
Hi Barb,
=INDIRECT("Program_"&A1&"_"&B1)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Barb Reinhardt" wrote in message
...
| I'd like to reference a named range that is variable.
|
| Let's say I have a Range called "Program_1_2" and A1 = 1 and B1 = 2
|
| How do I do something like this "Program_"&A1&"_"&B1 and get it to display?
|
| Thanks,
| Barb Reinhardt
|