|
本帖最后由 glhfgtd 于 2012-2-7 06:53 编辑
用了几周在论坛中发现的excel修改历史记录,突然发现,当同时选择两个或以上单元格后,若进行单元格的改动就会出现代码运行错误,请见附件,特此求教大家给予更正完善, 十分感谢{:30:}。
11120414498526.rar
glhfgtd 发表于 2012-2-7 10:36
我的意思是说:多个单元格选择起来后,无论是Tab逐个改动单元格,或是用复制粘贴功能集体改动,代码都可正常 ...
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim x As Range
- Dim r As Long
- '保存新值
- For Each x In Target
- With Sheets("日志")
- r = .[A65536].End(xlUp).Row + 1
- .Cells(r, 1) = Time
- .Cells(r, 3) = x.Value
- .Cells(r, 4) = x.Address
- End With
- Next x
- End Sub
-
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim y As Range
- Dim r As Integer
- '保存原值
- For Each y In Target
- With Sheets("日志")
- .Cells(.[b65536].End(xlUp).Row + 1, 2) = y
- End With
- Next y
- End Sub
复制代码
记录你的修改2.rar
(10.56 KB, 下载次数: 107)
|
|