Auto FIlter
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 |
Auto FIlter
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 . |
Auto FIlter
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 |
All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com