Auto FIlter

R

Ramone

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
 
D

DavidC

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
 
N

Nigel

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

Cheers
Nigel
 
Top