Function Nhascomm(rng As Range) As Integer
Dim mycell As Range
Dim k As Integer
For Each mycell In rng
If Not mycell.Comment Is Nothing Then
k = k + 1
End If
Next
Nhascomm = k
End Function
Function Nhascomm(rng As Range) As Integer
Dim mycell As Range
Dim k As Integer
For Each mycell In rng
If Not mycell.Comment Is Nothing Then
k = k + 1
End If
Next
Nhascomm = k
End Function