Sub 生成入库数据2()
Dim c As Range, n As Integer
Application.ScreenUpdating = False
Application.ScreenUpdating = False
'Sheets("入库数据").Select
'ActiveSheet.Unprotect ("372331") '解除对工作表的保护
a = Sheets("入库数据").Range("A65536").End(xlUp).Row
If a > 999999999 Then
MsgBox "您的程序过了试用期,数据不能被保存", vbOKOnly, "试用期提示"
Exit Sub
End If
With Sheets("入库数据")
.Unprotect Password:="9"
End With
'Sheets("入库单").Select
k = 6
Do While Not IsEmpty(Sheets("入库单").Cells(k, 3).Value)
k = k + 1