Sub copie_zone_texte()
Dim x#, y#
Application.ScreenUpdating = False
With Sheets("facture")
With .Shapes("TextBox 3")
x = .Left
y = .Top
.Delete 'supprime l'objet
End With
Sheets("devis").Shapes("TextBox 3").Copy 'copier
.Activate
.Paste 'coller
Selection.Left = x
Selection.Top = y
ActiveCell.Activate
End With
End Sub