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.