Hi

I'm trying to filter a table in a macro by the contents of a cell which is
outside the table range. (Basically, the user, on a separate sheet picks
from a list box what they want to filter by, and the results go into a linked
cell as usual). At present I am using AutoFilter, but can't seem to put the
cell reference in the Criteria1? Is it possible or am I using incorrect
syntax?

Any help would be great!