Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My filter is not returning any data. Here is the applicable portion of the
code: Sub WorkOrdersCompletedByDate() Prompt = "Please Enter Beginning Date (mm/dd/yy). Hitting 'Cancel' Will End the Macro." Title = "Print Completed Work Orders for a Specific Date Range" newname1 = InputBox(Prompt, Title, "mm/dd/yy") Prompt = "Please Enter Ending Date (mm/dd/yy). Hitting 'Cancel' Will End the Macro." Title = "Print Completed Work Orders for a Specific Date Range" newname2 = InputBox(Prompt, Title, "mm/dd/yy") Selection.AutoFilter Field:=12, Criteria1:="=Newname1", Operator:=xlAnd _ , Criteria2:="<=newname2" End Sub Is there a # format issue here???? Someone please help!!!! THANK YOU!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter problem | New Users to Excel | |||
Filter problem | Excel Worksheet Functions | |||
filter problem | Excel Discussion (Misc queries) | |||
Filter problem | Excel Worksheet Functions | |||
filter problem | Excel Programming |