Sub 批注()
m = Cells.Find("*", , , , , xlPrevious).Row
For i = 1 To m
n = Cells(i, Columns.Count).End(xlToLeft).Column
For j = 1 To n
If (Cells(i, j) = 29) + (Cells(i, j) = 18) And Cells(i, j).Comment Is Nothing Then
Cells(i, j).AddComment.Text Cells(i, j).Text
End If
Next
Sub 批注()
m = Cells.Find("*", , , , , xlPrevious).Row
For i = 1 To m
n = Cells(i, Columns.Count).End(xlToLeft).Column
For j = 1 To n
If (Cells(i, j) = 29) + (Cells(i, j) = 18) And Cells(i, j).Comment Is Nothing Then
Cells(i, j).AddComment.Text Cells(i, j).Text
End If
Next