Sub cax() Dim i&, Myr&, Arr, bj$, mc, Arrsz, b, ii&, n% Dim Sht1 As Worksheet, Sht2 As Worksheet Set Sht1 = Sheets("成绩表") Set Sht2 = Sheets("年级前N名") Myr = Sht1.[a65536].End(xlUp).Row Arr = Sht1.Range("a5:p" & Myr) Sht2.Activate [a6:p1000] = "" bj = [f2] mc = [l2]: n = 5 Arrsz = Split(bj, "、") For ii = 0 To UBound(Arrsz) b = Arrsz(ii) For i = 1 To UBound(Arr) If Arr(i, 1) = Val(b) And Arr(i, 15) < mc + 1 And Arr(i, 15) <> "" Then n = n + 1 Cells(n, 1).Resize(1, 16) = Application.Index(Arr, i, 0) End If Next Next End Sub |