Sub atest()
Dim rngS As Range, rngD As Range, nBu$
With ActiveCell
Set rngS = .EntireRow: nBu = .Parent.Name
End With
Set rngD = Sheets("Feuil2").Range("A65536").End(xlUp)(2)
rngS.Copy rngD
rngD.AddComment "Ce bordereau vient de :" & Chr(10) & nBu
End Sub