Autofilter & Long strings i.e 255 chrs
 

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

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

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