Thread: Autofilter & Long strings i.e 255 chrs
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kieran H Kieran H is offline
external usenet poster
  
Posts: 32
Default Autofilter & Long strings i.e 255 chrs
On Feb 8, 2:45 pm, Dave Peterson wrote:
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

Understood - many thanks

Reply With QuoteReply With Quote