|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub test()
Dim sht
Application.DisplayAlerts = False '禁止弹出警告
Application.ScreenUpdating = False '禁止屏幕刷新
For Each sht In Sheets
If sht.Name <> "王村" Then
r = UBound(Sheets("王村").UsedRange.Value) + 1
If sht.[a2] = "" Then
sht.UsedRange.Copy Sheets("王村").Cells(r, 1)
sht.UsedRange = ""
Else
sht.UsedRange.Offset(1).Copy Sheets("王村").Cells(r, 1)
sht.UsedRange = ""
End If
End If
Next
MsgBox "恭喜你!操作成功!", 64, "温馨提示……"
Application.DisplayAlerts = True '允许警告
Application.ScreenUpdating = True '允许刷新
End Sub |
|