Brilliant.
Now if I have this in a macro it will not accept it. The macro reads ...
ActiveCell.FormulaR1C1 = ""=abcd"" and it doesnt want to accept "" times two.

"Debra Dalgleish" wrote:

For the criteria, use: ="=abcd"


Yaasien wrote:
Excel Filter Criteria ="abcd" but result includes "abcdefg" How do I restrict
results (in one cell) to just "abcd"


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html