Named ranges reset.

R

rasputin

Hi all,

I have a range called Criteria in Excel (2000, SP3 under W2K) that has
the formula "=OFFSET(T_MEAN!R426C9,0,0,a,b)", where a and b are
references to single cells in the same worksheet.

I am trying to dynamically change the criteria range for advanced
filters, and am using the above range to do so. However, once I invoke
the advanced filter the definition of the named range changes to a
static reference of the sort =MySheet!$I$426:$I$427.
Any ideas on why this happens?

TIA

Ramu K.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Named Range formula without using OFFSET function 5
Define a Range based on Cell Values 2
Named Range that uses "relative" range - Possible? 5
Macro needs updated Range name addresses 3
How do I use advance filter correctly? 2
Constructing Range Name calls with Concatenate 4
Dynamic Named Ranges 3
runtime error 9 subscript out of range 1

Top