Indirect function with Named multiple ranges

  • Thread starter Thread starter Damian
  • Start date Start date
D

Damian

I found that when trying to apply the INDIRECT function to
a Named Range that defines a multiple selection range, it
doesn't work.

Does anybody know anything about this? Any patch? or
workaround?

Thanks!
 
Hi Jim,
I'll try to be more clear:
Suppose you have two sets of numerical values. One set is
stored in cells A1 trough A10, and the other set is in
cells C1 trough C10.

I define a named range as follows:
Data=A1:A10;C1:C10

Case a)
The function:
SUM(INDIRECT("A1:A10;C1:C10"))
works fine.

Case b)
The function:
SUM(INDIRECT(Data))
returns an error

In my understanding, Case b) should work exactly as Case
a), but it doesn't.

Thanks Jim.
 
Perhaps you got Case a) to return the correct value, but I would have to see
it before I would believe. <g>
 
With the naemd range enclosed in quotes, #REF! is returned; without the
quotes xl recognizes the range and returns #VALUE!.

Why not make it easy and tell us how your data is arranged, the type of
data, and what you are trying to achieve.
 
Back
Top