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.
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,
I am currently using the following code which filters a table of data for rows which begin with the value of the StartDate range.
Code:
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,