JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have data in an array but need a subset of this data where Column 5 <> "Setup" or Column 5 <>"Jack"
Closest code found but unable to adjust is:
Gives run-time error '13' Type mismatch, I'm guessing my 2nd argument is incorrect.
Can anyone suggest please?
TIA,
Jack
I have data in an array but need a subset of this data where Column 5 <> "Setup" or Column 5 <>"Jack"
Closest code found but unable to adjust is:
Code:
Function SubSet(ByRef WholeSet As Variant) As Variant
SubSet = Application.Index(WholeSet, "" <> "" & Array("Setup", "Jack"), 5)
End Function
Can anyone suggest please?
TIA,
Jack