jpkeller55
New Member
- Joined
- May 27, 2004
- Messages
- 11
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.
Code:
'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"