- Sub 获取非是的四列资料()
- '与原代码接近
- Dim vData As Variant, nRow As Long, nFill As Long, nCol As Long
- vData = Cells(1, 1).CurrentRegion
- For nRow = 1 To UBound(vData)
- If vData(nRow, 4) <> "是" Then
- nFill = nFill + 1
- For nCol = 1 To UBound(vData, 2)
- vData(nFill, nCol) = vData(nRow, nCol)
- Next
- End If
- Next
- [F:I].ClearContents
- If nFill > 0 Then [F1].Resize(nFill, UBound(vData, 2)) = vData
- End Sub
- Sub 获取是的两列资料()
- Dim vData As Variant, nRow As Long, nFill As Long, nCol As Long
- vData = Cells(1, 1).CurrentRegion
- For nRow = 1 To UBound(vData)
- If vData(nRow, 4) = "是" Then
- nFill = nFill + 1
- vData(nFill, 1) = vData(nRow, 1)
- vData(nFill, 2) = vData(nRow, 4)
- End If
- Next
- [L:M].ClearContents
- If nFill > 0 Then [L1].Resize(nFill, 2) = vData
- End Sub
复制代码 |