Filter in macro
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!
.
|