Describe everything you have. When you apply the filter what's the criteria
range, what is in the criteria range, what are the headers in your table
etc.

When I create a test table, with the headers Flicnum and Actornum, put some
data in there, then use H1:H2 as criteria range with Flicnum in H1 and
=Flicnum in H2 it filters fine, when I change the value in the named cell
called Flicnum and refresh the filter it works fine and filter for the new
value
--


Regards,


Peo Sjoblom


"Pieyed Piper" g wrote in
message ...


I want to use a named range, which is a single value as the "equal to"
criteria in the advanced filter dialog box.

I have a named range of a single cell I call "FlicNum".

I have a list of 'flicnums' and actor numbers. With over 130 thousand
DVDs in the main list, the actor list index is about 660 thousand records
long.

If I filter on "FlicNum" I should only see a list of actor numbers that
tie to that FlicNum. That is the goal. Getting the filter to accept my
"variable" is the obstacle.

If I enter a 'flicnum' (DVD ID number) by hand, it filters on it just
fine. How do I plug in a "variable", or named range into a filter dialog
or specification?