S
Sam
Hello everyone,
I'm having trouble using a dynamic named range through
Indirect.
I have a dropdown in cell C1 that selects the month. Each
month has a static named range. I call the month in a
formula that uses Indirect. This worked fine until I tried
using dynamic named ranges for the months.
When using dynamic ranges INDIRECT($C$1) now evaluates to
#REF!. If I change back to static named ranges then the
formula once again works properly.
The formula for the dynamic range is correct:
=OFFSET(2004!$C$1,0,0,COUNTA(2004!$A:$A)-1,1)
Any ideas?
I'm having trouble using a dynamic named range through
Indirect.
I have a dropdown in cell C1 that selects the month. Each
month has a static named range. I call the month in a
formula that uses Indirect. This worked fine until I tried
using dynamic named ranges for the months.
When using dynamic ranges INDIRECT($C$1) now evaluates to
#REF!. If I change back to static named ranges then the
formula once again works properly.
The formula for the dynamic range is correct:
=OFFSET(2004!$C$1,0,0,COUNTA(2004!$A:$A)-1,1)
Any ideas?