Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA auto filter question
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é |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA auto filter question
Andre
Off to test but it should work if you take the quotes from around the variable -- 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é |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA auto filter question
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é |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA auto filter question
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é |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-filter Question | Excel Discussion (Misc queries) | |||
Auto Filter question | Excel Worksheet Functions | |||
Auto Filter Question? | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions |