|
为表格减肥!
代码:
Sub 表格减肥()
'清除多余的行
For i = 1 To 256
j = Cells(65535, i).End(xlUp).Row
If j > k Then
k = j
Else
k = k
End If
Next
Range(Cells(k + 1, 1), Cells(65536, 256)).Clear
'清除多余的列
For i = 1 To k
j = Cells(i, 256).End(xlToLeft).Column
If j > n Then
n = j
Else
n = n
End If
Next
Range(Cells(1, n + 1), Cells(65536, 256)).Clear
End Sub
|
|