|
- Sub zhoucs00()
- Dim only As New Collection, i As Integer
- On Error Resume Next
- For i = 2 To 23
- only.Add Cells(i, 1).Value, CStr(Cells(i, 1).Value)
- If Err = 0 Then
- j = j + 1
- Cells(i, 1).Resize(1, 12).Copy Cells(25 + j, 1)
- Else
- Err.Clear
- End If
- Next i
- MsgBox j
- End Sub
复制代码 |
评分
-
查看全部评分
|