Hello all
Can anyone please spot my error on this code
I am trying to filter on dates Greater than Today()
It is applying the filter on the correct column but it's not applying the value, net result everything is filtered out
Can anyone please spot my error on this code
I am trying to filter on dates Greater than Today()
It is applying the filter on the correct column but it's not applying the value, net result everything is filtered out
Code:
Dim Myval as Date
MyVal = Date
FilterRange.AutoFilter field:=24, Criteria2:=">" & MyVal