Private Sub Worksheet_Activate()
Dim n&, c As Range, t
n = 20 'nombre de lignes, à ajuster
Set c = [C12] 'début
t = Sheets("Agents").[A2].Resize(n, 2) 'adapter A2 si nécessaire
c.Resize(n) = t
c.Resize(n).ClearComments
For n = 1 To n
If t(n, 2) <> "" Then
c(n).AddComment t(n, 2)
c(n).Comment.Visible = False
c(n).Comment.Shape.TextFrame.AutoSize = True
End If
Next
End Sub