Alternatives to advance filtering?

E

Eddie Holder

Anyones help would be greatly appreciated. I believe that when using the
advance filter function it applies an asterix/wildcard at the end of the
word. Can anyone tell me what the VBA coding is to look for a true/exact word
- i think it incorporates and = sign immediately before the word?
 
D

Dave Peterson

Enter this as text (preform the cell as text or start with an apostrophe):

'=Ed
(to retrieve all the Ed's, but not the Eddie's.)

Or use a formula that evaluates to that same text string.
="="&"ED"
 
L

Lori

Another option is to check "transition formula evaluation" in Excel options,
before applying the filter, but make sure to uncheck it off after.

ActiveSheet.TransitionExpEval=True
Range.AdvancedFilter ...
ActiveSheet.TransitionExpEval=False
 
Top