Alternatives to advance filtering?

  • Thread starter Thread starter Eddie Holder
  • Start date Start date
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?
 
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"
 
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
 
Back
Top