|
小弟从网上抄的代码如下,想实现的功能是记录修改过的内容。但是在运行过程中,会跳出(运行时错误“7”,内存溢出),点击调试,倒数第二行XX = Target.Value显示黄色,哪位大神能够帮忙解答一下。
Dim XX
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ROW1
With Sheets("日志")
On Error Resume Next
If XX <> Target Then
ROW1 = Sheets("日志").[A65536].End(xlUp).Row + 1
.Cells(ROW1, 1) = Date
.Cells(ROW1, 2) = Time
.Cells(ROW1, 3) = XX
.Cells(ROW1, 4) = Target.Value
.Cells(ROW1, 5) = Target.Worksheet.Name
.Cells(ROW1, 6) = Target.Address
End If
End With
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
XX = Target.Value
End Sub
|
|