troubleshooting Question

Filter a VBA Array

Avatar of p-plater
p-platerFlag for Australia asked on
ProgrammingVisual Basic ClassicMicrosoft Excel
19 Comments4 Solutions1141 ViewsLast Modified:
Hello all

I have a Array with two fields of values.
I need to be able to filter the array so it only contains rows/records where the second column/Field equals a certain value (ie 5).

Can this be done with out copying to a worksheet and filtering the data?

(This filtering will need to be done fairly constantly while the project is being used.
Also it's only about 300 records so pasting to a worksheet, filtering and copying back seems an overkill)

Join our community to see this answer!
Unlock 4 Answers and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros