tdhood
Board Regular
- Joined
- Jul 25, 2005
- Messages
- 118
Hello, All -
I've just encountered some wierdness that I can't get past. I've got a spreadsheet with several dozen dynamic ranges - defined in the "Define Name" dialog box using the INDIRECT function.
As an example, I've got a dynamic range TestRange1 defined as so:
TestRange1=INDIRECT(Sheet1!$A$1)
The value in A1 is the string "Sheet1!$A$2:$A$21" (without quotes)
Here's where the wierdness pops up:
The function =ROWS(TestRange1) evaluates successfully to 20;while the function =ROWS(INDIRECT("TestRange"&"1")) coughs up a #REF!.
Now, it gets stranger: If I explicity define the ranges (instead of dynamic definitions), I can use the INDIRECT function to access the range.
Anybody seen this? Got a workaround?
tdh
I've just encountered some wierdness that I can't get past. I've got a spreadsheet with several dozen dynamic ranges - defined in the "Define Name" dialog box using the INDIRECT function.
As an example, I've got a dynamic range TestRange1 defined as so:
TestRange1=INDIRECT(Sheet1!$A$1)
The value in A1 is the string "Sheet1!$A$2:$A$21" (without quotes)
Here's where the wierdness pops up:
The function =ROWS(TestRange1) evaluates successfully to 20;while the function =ROWS(INDIRECT("TestRange"&"1")) coughs up a #REF!.
Now, it gets stranger: If I explicity define the ranges (instead of dynamic definitions), I can use the INDIRECT function to access the range.
Anybody seen this? Got a workaround?
tdh