...
If Trouve_Photo Then
Photo.Copy
[D9].ClearContents
ActiveSheet.Paste
Selection.Name = "Photo"
Shapes("Photo").Top = [D9].Top + 1
Shapes("Photo").Left = [D9].Left + ([D9].Width - Shapes("Photo").Width) / 2
Shapes("Photo").Height = [D9].Height - 2
'Shapes("Photo").Top = [D9].Top + ([D9].Height - Shapes("Photo").Height) / 2
Else
[D9] = "X"
End If
...