Public Sub aaa()
'sheet2表内C列的内容,作为批注添加到sheet1表D列
'(sheet2表A列为sheet1表D列的列表)
Dim t As String
Dim s1 As Worksheet: Set s1 = Worksheets("sheet1")
'sheet1表,需要批注的表(必要时更改表名,""内的内容)
Dim s2 As Worksheet: Set s2 = Worksheets("sheet2")
'sheet2表,批注数据来源表(必要时更改表名,""内的内容)
Dim rn As Range
Dim rn2 As Range: Set rn2 = s2.Cells(2, 1).Resize(s2.[a65536].End(xlUp).Row - 1, 3)
For Each c In s1.Cells(2, 4).Resize(s1.[d65536].End(xlUp).Row - 1, 1)
t = c.Value
Set rn = rn2.Find(t, LookIn:=xlValues, LookAt:=xlWhole)
If rn Is Nothing Then
t = "没有找到"
Else
t = rn.Offset(0, 2).Value
End If
c.ClearComments
c.AddComment t
Next
End Sub
--------------------
sheet1表,需要批注的表,需要批注的列:D列,从第二格开始
sheet2表,批注数据来源表
sheet1表D列的来源为sheet2表的A列,批注来源为sheet2表的C列
打开sheet1表,在表名上点右键,选“查看代码”,打开代码窗口,将上面的代码复制入其中,并根据实际情况,将代码内的表名改为实际表名(有注释),然后,按 F5 键运行程序
有其他问题,Hi 我
温馨提示:答案为网友推荐,仅供参考