|
用新建excel 打开 新11文件, 然后判断新11的 C列中 左边第一个字符不等于 “退” 的数据全部删除。
但是不知道为什么 , 一次性删除不了?
请各位帮忙看看
咋回事呀
谢谢了
回复 zss427607 的帖子
- Private Sub CommandButton1_Click()
- Dim str, wk, A, B, i, s
-
- str = "新11.xls"
- On Error Resume Next
- Workbooks(str).Close
- On Error GoTo 0
- Set wk = Workbooks.Open(ThisWorkbook.Path & "" & str)
- With wk.Sheets("sheet1")
- A = .Range("a1:c" & .Range("a65536").End(xlUp).Row)
- ReDim B(1 To UBound(A), 1 To UBound(A, 2))
- For i = 1 To UBound(A)
- If Left(A(i, 3), 1) = "退" Then
- s = s + 1
- B(s, 1) = A(i, 1)
- B(s, 2) = A(i, 2)
- B(s, 3) = A(i, 3)
- End If
- Next i
- If s > 0 Then
- .Cells.Clear
- .Range("a1").Resize(s, UBound(B, 2)) = B
- End If
- End With
- Set wk = Nothing
- Application.DisplayAlerts = False
- Workbooks(str).Close True
- End Sub
复制代码这样的,可以吗{:041:}
|
|