About Us

Andre Croteau

Thank you...works well now

"Nick Hodge" wrote in message
...
Andre

Tested...yes fine

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Andre Croteau" wrote in message
...
Hi,

I have data in cells A3:C200, with the auto filter ON

I am trying to automate some procedures, and would like to put a value
in
cell say "A1" which would represent the auto filter query I am looking
for
column "C"

so far I have tried

Dim WSCode As String
WSCode = Worksheets("Sheet1").Cells(1, 1).Value
Selection.AutoFilter Field:=3, Criteria1:="WSCode"

but it doesn't work....

Can someone please give me a hand?

Thanks

André

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto-filter Question	Brig	Excel Discussion (Misc queries)	1	April 5th 08 05:00 AM
Auto Filter question	Michael Raphael	Excel Worksheet Functions	3	August 11th 06 04:28 PM
Auto Filter Question?	Ducky	Excel Discussion (Misc queries)	3	April 19th 06 04:16 PM
auto filter question	Juco	Excel Worksheet Functions	0	November 29th 04 02:48 PM
auto filter question	Juco	Excel Worksheet Functions	1	November 28th 04 02:51 PM