- Sub 在职人员()
- Dim ar, arr(), i&, m&
- ar = Range("A5").CurrentRegion
- ReDim arr(1 To UBound(ar), 1 To 2)
- For i = 1 To UBound(ar)
- If ar(i, 5) = "" Then
- m = m + 1
- arr(m, 1) = ar(i, 1)
- arr(m, 2) = ar(i, 2)
- End If
- Next
- Range("H6").Resize(UBound(ar), 2) = arr
- End Sub
复制代码
1989.zip
(10.25 KB, 下载次数: 0)
|