dim array()
'array_old()为原来的数组
Dim k,i,j
Dim str
k=Lbound(array_old)
array(0)=array_old(k)
str=","& array(0) &","
j=1
for i=k+1 to Ubound(array_old)
if not InStr(str,","& array_old(i) &",") then
array(j)=array_old(i)
str=str & array_old(i) &","
j=j+1
end if
next
这样array()里就没有重复的了。。
代码没验证。