Sub 数组方法1()Dim arr, t
Dim x AsIntegerDim sr AsString, sr1 AsString
清除颜色
t =Timer
arr = Range("d2:d"& Range("a65536").End(xlUp).row)For x =1ToUBound(arr)If x =UBound(arr)And sr <>""Then Range(Left(sr,Len(sr)-1)).interrior.ColorIndex =3If arr(x,1)>500Then
sr1 = sr '这里的sr1作用是预防字符串长度大于250
sr = sr &