Hello,

I'm trying to use a named range for my criterion in an advanced filter, to
no avail.

Here is what I'd like to do:

I have a single cell that is named SpecDate. On another worksheet, I have
an advanced filter where I would like to specify SpecDate. If I key the
date in manually no problem. But the moment I use a named range, it doesn't
work.

Are named ranges allowable in Adv Filter criteria?

Thanks!