Hi Ron
thanks for this - only thing I'm not sure of is where to put the
rng.AutoFilter Field:=1, Criteria1:="=" & DateSerial(1947, 2, 23), _
Operator:=xlOr, Criteria2:="<=" & DateSerial(1988, 5, 7) ' yyyy-mm-dd
format
bit within the code.
Many thanks
--
flurry
------------------------------------------------------------------------
flurry's Profile:
http://www.excelforum.com/member.php...o&userid=34303
View this thread:
http://www.excelforum.com/showthread...hreadid=548113