|
- Sub CheryBTL()
- Dim str As String, rng As Range
- Dim i As Integer, Rrow As Integer, Cclm As Integer
- Stemp = "单位存款"
- str = Dir(ThisWorkbook.Path & "\*xls", vbNormal)
- Do While str <> ""
- If str <> "代码.xls" Then
- Workbooks.Open ThisWorkbook.Path & "" & str
- With Workbooks(2)
- For i = 1 To .Sheets.Count
- For Each rng In .Sheets(i).UsedRange
- If rng.Value = "单位存款" Then
- Rrow = rng.Row - 1
- Cclm = rng.Column - 1
- If Rrow > 0 Then
- .Sheets(i).Range(.Sheets(i).Cells(1, 1), .Sheets(i).Cells(Rrow, 1)).Select
- Selection.EntireRow.Delete Shift:=xlUp
- End If
- If Cclm > 0 Then
- .Sheets(i).Range(.Sheets(i).Cells(1, 1), .Sheets(i).Cells(1, Cclm)).Select
- Selection.EntireColumn.Delete Shift:=xlToLeft
- End If
- Exit For
- End If
- Next
- Next i
- .Close Savechanges:=True
- End With
- End If
- str = Dir
- Loop
- End Sub
复制代码 将此代码工作薄放在同一文件夹中,点击执行按钮即可。
代码.rar
(8.89 KB, 下载次数: 10)
|
|