Thread: Autofilter & Long strings i.e 255 chrs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Autofilter & Long strings i.e 255 chrs
I don't think MS has ever shared the reasons.

But Debra Dalgleish does share some workarounds:
http://contextures.com/xlautofilter02.html#String

Kieran H wrote:

To all,

Does the custom option in Autofilter have a limit on the length of
string/field it is prepared to search.

I have evidence that this the case but would like to understand the
reasons

Cheers

Kieran

--

Dave Peterson
Reply With QuoteReply With Quote