VBA Filter method

[ImranBhatti]

Hi,

I have a single dimensional array

x=Array("aa","bb","cc","dd","ee","ff","gg","hh","ii","jj","kk")

want to filter and get an array that should have only

"cc","dd","ee","ff"

name for output array is "Refined"

I know it can be done with loop but want to know can it be done with vba filter method (Refined=Filter(x,"<>aa,bb,gg,hh,ii,jj,kk")

[romperstomper]

No it can't, at least not without a loop.

[ImranBhatti]

currently I am using a sheet column writing raw array to sheet

sort it
filter it

loading visible cells to array. not efficient but for the time being.