Does anybody know if there is a character limit for an autofilter search in Excel 2003? I am using the code below on a button that a user can input filter criteria for a cell that contains the input string. However, it looks like the filter is not finding strings in cells when the string is past 250 characters or so. Is this known and is there a work around? Thanks for any help.
'Variables used by the macro Dim FilterCriteria Dim CurrentFileName As String 'Get the current file's name CurrentFileName = ActiveWorkbook.Name On Error Resume Next ActiveSheet.AutoFilterMode = False On Error GoTo 0 'Apply Autofilter Range("A2:z10000").AutoFilter 'Get the filter's criteria from the user FilterCriteria = InputBox("Enter Drug Name") If FilterCriteria = "" Then Exit Sub FilterCriteria = Replace(FilterCriteria, "*", "") FilterCriteria = "*" & FilterCriteria & "*" 'Filter the data based on the user's input Range("A2:z10000").AutoFilter field:=16, Criteria1:=FilterCriteria, Operator:=xlOr, Criteria2:="=UNIVERSAL"