you could just possibly tell me the correct syntax!


" wrote:

hi,
how do we know if your are using incorrect syntax unless
you post your code?

-----Original Message-----
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!
.