第1个回答 2013-12-13
打开VBA编辑器,在sheet1工作表代码中输入如下代码,即可实现:Option ExplicitPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim aSheet As Worksheet
Dim bSheet As Worksheet
Set aSheet = Worksheets("Sheet1")
Set bSheet = Worksheets("Sheet2")
aSheet.Activate
With bSheet
If .Range("IV65536") = "" Then
.Range("IV65536") = 1
.Range("A1") = Range("A1")
End If
If .Cells(.Range("IV65536"), 1) = Range("A1") Then
Exit Sub
Else
.Range("IV65536") = .Range("IV65536") + 1
.Cells(.Range("IV65536"), 1) = Range("A1")
End If
End With
End Sub