Hello All,

I'm trying to learn how to use autofilter, and I don't
have it figure out can someone help please. I'm using the
following code:

worksheets("sheet1").range("a1").autofilter
field:=1
criterial:="otis"

thanks for any help

First do you have a list in column A?
Second does the word Otis appear in that list?

Otherwise the code works well and should give you the drop
down arrow oncoulmn A when the code 'visibledopdown=True'

Best of luck
DavidC
-----Original Message-----
Hello All,

I'm trying to learn how to use autofilter, and I don't
have it figure out can someone help please. I'm using the
following code:

worksheets("sheet1").range("a1").autofilter
field:=1
criterial:="otis"

thanks for any help
.

Set up the autofilter manually, then when your happy, use the macro recorder
and you'll see the code required.

Cheers
Nigel

"Ramone" wrote in message
...
Hello All,

I'm trying to learn how to use autofilter, and I don't
have it figure out can someone help please. I'm using the
following code:

worksheets("sheet1").range("a1").autofilter
field:=1
criterial:="otis"

thanks for any help