| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable names for named range
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Variable names for named range
I should have posted that I tried using that before I posted this request and
I get a #REF error. "Niek Otten" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Variable names for named range
Hi Barb,
Are there any invisible characters in A1 or B1? Check with the LEN() function. I assume you use A1 reference style, not R1C1. -- Kind regards, Niek Otten Microsoft MVP - Excel "Barb Reinhardt" wrote in message ... |I should have posted that I tried using that before I posted this request and | I get a #REF error. | | "Niek Otten" wrote: | | 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 | | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Variable names for named range
No invisible characters
I'm also using the A1 reference style. "Niek Otten" wrote: Hi Barb, Are there any invisible characters in A1 or B1? Check with the LEN() function. I assume you use A1 reference style, not R1C1. -- Kind regards, Niek Otten Microsoft MVP - Excel "Barb Reinhardt" wrote in message ... |I should have posted that I tried using that before I posted this request and | I get a #REF error. | | "Niek Otten" wrote: | | 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 | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| using a "variable" in range names | Excel Discussion (Misc queries) | |||
| DDE linking with variable from named cell! | Links and Linking in Excel | |||
Linear Mode
