|
楼主 |
发表于 2013-3-26 16:59
|
显示全部楼层
本帖最后由 qhllqhll 于 2013-3-26 18:05 编辑
无聊的疯子 发表于 2013-3-26 16:54
sql 的,帮你叫了烟花了,晚上他来
大师您好:我想搜寻到 s 列的最后一行,下面的代码应该怎样修改
谢谢
Private Sub CommandButton1_Click()
Dim Sh As Worksheet, Sht As Worksheet
Dim H As Long, L As Integer
Set Sht = Sheets("汇")
Sht.Rows("4:10000").ClearContents
For Each Sh In Worksheets
If Sh.Name <> Sht.Name Then
With Sh
H = .Range("A65536").End(xlUp).Row
L = .Range("IV1").End(xlToLeft).Column
With .Range(.Cells(1, "A"), .Cells(H, L))
H = Sht.Range("A65536").End(xlUp).Row + 2
.AdvancedFilter 2, Sht.Range("B1:B2"), Sht.Cells(H, "A"), True
If H > 4 Then Sht.Rows(H - 1 & ":" & H).Delete
End With
End With
End If
Next
End Sub
|
|