1004 Error when using an array for auto-filter criteria

[bcrpanther]

Hello to all,
I'm getting a 1004 error when trying to apply a autofilter using a array. Bellow is the line of code in question:


Worksheets(CONBaselineSheet).Range("A1:" & GetColumnLetter(CONLastTaskColumn) & GBLProjectFile.TotalTasks + 1).AutoFilter Field:=varField.Field, Criteria1:=varField.Values, Operator:=xlFilterValues


Variable values:

Range => "A1:" & GetColumnLetter(CONLastTaskColumn) & GBLProjectFile.TotalTasks + 1 equates to => "A2:AB1250"
varField.field => 6 and I varified that the field exsists
varValues is a variant array with 2 values "SHS", "LT"


Any Ideas?

Thanks!!

 

[JackDanIce]

Welcome to the board. I think your Criteria1:=varField.Values should be Criteria1:=varValues

Try

With Worksheets(CONBaselineSheet).Range("A1:" & GetColumnLetter(CONLastTaskColumn) & GBLProjectFile.TotalTasks + 1)
  .AutoFilter Field:=varField.Field, _
  Criteria1:=varValues, _
  Operator:=xlFilterValues
End With

 

[bcrpanther]

Welcome to the board. I think your Criteria1:=varField.Values should be Criteria1:=varValues

Try

With Worksheets(CONBaselineSheet).Range("A1:" & GetColumnLetter(CONLastTaskColumn) & GBLProjectFile.TotalTasks + 1)
  .AutoFilter Field:=varField.Field, _
  Criteria1:=varValues, _
  Operator:=xlFilterValues
End With

Thanks JackDanIce for the reply... varField is a class module with a procedure called values (which is a declared as as a string Array. ) I have tried to just use the Array statement with static values just see it work, but I still get the same 1004 error. I'm sure is it something simple that I'm missing

 

[Norie]

What exactly does varField.Values return?

 

[bcrpanther]

What exactly does varField.Values return?

it returns a array of string values e.g. "SHS", "LT"