Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set values in an Array
Is there a way to load an array with data from a worksheet? Here is
the code I have. ActiveSheet.ListObjects("List12559").Range.AutoFil ter 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking Up Two Values in an Array | Excel Worksheet Functions | |||
looking a value in an array text values | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
To get values into an array | Excel Worksheet Functions | |||
Use array to return array of values | Excel Worksheet Functions |