Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
executing an autofilter in VB
Hello everyone,
I tought I could find the answer by myself and not disturb you, but it have 2/3 days that I've been searching solutions to my problem through the NG and did not find any anwser. Here is my problem : I have programmed an autofilter under VB in Excel...the thing is that when I run it from a userform...the autofilter is empty. And when i have a look in the "personnalised"...my criteria are correct..so I click on the OK button and finally the filtered data are displayed..... What I don't understand is why those data are not displayed automatically. Here is my piece of VB program (which is very basic VB!!!) : Rows("5:5").Select ' this select the entire line where there are the titles of the columns Selection.AutoFilter Selection.AutoFilter Field:=9, Criteria1:="=" & Format(Extractions.LDDate1.Date, "dd/mmm/yyyy"), Operator:=xlAnd, Criteria2:="<=" & Format(Extractions.LDDate2.Date, "dd/mmm/yyyy") nota : extractions is my userform, LDDate1 & LDDate2 are the databox which gives the criterion for the autofilter. thanks in advance for anyhelp, I really don't know what to do.... Angélique |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
executing an add in | Excel Programming |