VBA Autofilter commands

[tanny81]

Hi All,

I am currently using the following code which filters a table of data for rows which begin with the value of the StartDate range.

Selection.AutoFilter Field:=7, Criteria1:=StartDate & "*"

In this code "*" indicates that the filter should use Auto Filter > Custom > Begins With

Does anybody know what charactor i should use to filter for the following:
Greater than or equal to
Less than or equal to
equal to

Thanks,

 

[stanleydgromjr]

tanny81,

Try recording several small macros, one for each of the following, to see the code that they create:
Greater than or equal to
Less than or equal to
equal to


Have a great day,
Stan

 

[royUK]

Why not use the macro Recorder to check?

http://www.excel-it.com/record_macro.htm

 

[tanny81]

Hi All,

I've solved the first problem, and can now get the autofilter to work as intended, however it returns no result when run using vba.

The code is

Selection.AutoFilter Field:=7, Criteria1:=">=" & StartDate, Operator:= _
        xlAnd, Criteria2:="<=" & EndDate

Where the ranges both equal dates. Doe's anybody know what would cause this?

Thanks,

 

[tanny81]

Ok,

I might have part of the solution to this. If i manually perform a text to columns function on the relevant field and then run my macro it seems to work ok. However, if i get a macro to run the text to columns function it removes the leading zero from the dates which are the 9th or earlier and then the auto filter doesn't work again.

Is there anything i can do with my code to resolve this?