本帖最后由 仔仔 于 2012-6-11 00:42 编辑
这么大个循环
应该是这个意思吧
Sub comadd()
For Each aa In Range("b4:bx5001")
aa.ClearComments
If aa <> "" Then
For i = 3 To Sheet2.Range("b65536").End(xlUp).Row
If aa = Sheet2.Cells(i, 2) Then
For y = 3 To 11
With Sheet2
ff = ff & .Cells(2, y) & ":" & .Cells(i, y) & Chr(10)
End With
Next
MsgBox ff
With aa
.AddComment (ff)
.Comment.Shape.Height = 120.75
.Comment.Shape.Width = 167.25
End With
ff = ""
End If
Next
End If
Next
End Sub