|
Sub t()
Dim i%, m, s, arr, r%, fso, fs, sh, brr, mpath, wb
mpath = "E:\VBA\清除文件夹下各表中的行\文件" '这个要修改一下路径
Set fso = CreateObject("Scripting.FileSystemObject")
Set fs = fso.getfolder(mpath).Files
For Each f In fs
Set wb = Workbooks.Open(f)
With wb.ActiveSheet
arr = .UsedRange
r = .[iv1].End(xlToLeft).Column
For i = UBound(arr) To 1 Step -1
If .Range("a" & i) = "" Then
brr = .Range("a" & i).Resize(1, r)
Set sh = .Range("a" & i & ":n" & i)
s = sh.Sort(Range("a" & i), 1, , , , , Orientation:=xlSortRows)
If .Range("a" & i) = "" Then
Rows(i).Delete
Else
.Range("a" & i).Resize(1, r) = brr
End If
End If
Next i
wb.Save
wb.Close
Set wb = Nothing
End With
Next f
Set fs = Nothing
Set fso = Nothing
End Sub |
|