Hi there,

I'm having an issue with recording a macro for custom filter with cell
references. The macro doesn't record a generic reference, just the
cell value at the time of recording. I looked loooong and hard for the
solution here, but i just can't find it. The closest i have to the
answer i found here (courtsey Tom Ogilvy):-

Selection.AutoFilter Field:=1, Criteria1:="=*" & Range("M13").Value _
& "*"

I tried playing around with the above but come unstuck when trying to
do a less than or equals to.

I desperately need help to this solution to finish off a project before
the weekend's out. Please, please please with extra whipped cream
help.

Chris

P.s could someone explain what the * element of the code is for?


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=557087