Private Sub 查找_Click() ShName = Range("D5") With Sheets(ShName) A = .Range("A65536").End(xlUp).Row Range("E5:G5") = .Range("B" & A & ":D" & A).Value End With End Sub Private Sub 记录_Click() If Application.WorksheetFunction.CountA(Sheets("记录查找").Range("D11:F11")) = 0 Then MsgBox "你让我记录什么东西???", vbOKOnly Exit Sub End If ShName = Range("D11") With Sheets(ShName) A = .Range("A65536").End(xlUp).Row + 1 .Range("A" & A & ":D" & A) = Range("D11:G11").Value Sheets("记录查找").Select Range("D11:F11").Select Selection.ClearContents Range("C4").Select End With End Sub
|