J
jlclyde
Is there a way to load an array with data from a worksheet? Here is
the code I have.
ActiveSheet.ListObjects("List12559").Range.AutoFilter Field:=1,
Criteria1:= _
Array("103", "113", "123", "213", "220", "227", "231", "235",
"290", "500", _
"540", "900"), Operator:=xlFilterValues
These values are in A1-A12. I am hoping to make this more dynamic so
when I add a criteria I can just add it to the sheet and not to the
sheet and the VBA macro.
Any help woudl be appreciated,
Jay
the code I have.
ActiveSheet.ListObjects("List12559").Range.AutoFilter Field:=1,
Criteria1:= _
Array("103", "113", "123", "213", "220", "227", "231", "235",
"290", "500", _
"540", "900"), Operator:=xlFilterValues
These values are in A1-A12. I am hoping to make this more dynamic so
when I add a criteria I can just add it to the sheet and not to the
sheet and the VBA macro.
Any help woudl be appreciated,
Jay