本帖最后由 zjdh 于 2012-10-11 13:27 编辑
Sub 录入数据() '录入数据
Application.ScreenUpdating = False
Dim rng As Range, m, n
Sheets("信息录入").Activate
n = [a:b].Find("合 计", , , 1).Row
For m = 4 To n
If Cells(m, 1) = "" Then Exit For
Next
m = m - 4
If [b4] = "" Then MsgBox "您没有输入任何信息,点我没用!": Exit Sub
Set rng = Sheets("数据库").[a65536].End(3).Offset(1)
rng.Offset(0, 1).Resize(m, 9) = [b4].Resize(m, 9).Value
rng.Resize(m) = Range("C2")
[b4:J23].ClearContents
Range("b4").Select
Application.ScreenUpdating = True
End Sub