Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mulitple Filter Selection
Hi,
I need to strenghten my code to allow the users to select 2 areas (or columns) in which the filter would operate. I was able to do one, but can't find a way to do more than one. ' Dim Message, Title, MyValue Dim ExactDate As Date Dim ExactCriterion As String Message = "Please Enter the Period, (00)" Title = "Title" MyValue = InputBox(Message, Title) ExactCriterion = Format(ExactDate, "mm/dd/yy") Range("Headers").AutoFilter Range("Headers").AutoFilter Field:=6, Criteria1:=MyValue Please help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Filter Selection to None | Excel Discussion (Misc queries) | |||
How do I filter or search mulitple for text strings? | Excel Discussion (Misc queries) | |||
Database - mulitple selection | Excel Worksheet Functions | |||
Copy selected mulitple worksheets to mulitple new workbooks | Excel Programming | |||
Copy selected mulitple worksheets to mulitple new workbooks | Excel Programming |