Sub AjoutImageFeuille_V02_PlusRespectTaille()
'MJ issu du travail de MichelXLD
Dim Shp As Shape, Fichier As String, iPict As IPictureDisp
n = 2
For Each cell In Selection
Fichier = cell 'Cells(1, 1)
'Fichier = "C:\Documents and Settings\mimi\dossier\Image2.jpg"
'expression.AddPicture(FileName, LinkToFile, SaveWithDocument, Left, Top, Width, Height)
'Set Shp = Feuil1.Shapes.AddPicture(Fichier, msoFalse, msoCTrue, 0, 0, 100, 90)
'ActiveSheet.Pictures.Insert Fichier
Set iPict = LoadPicture(Fichier): Larg = Round((iPict.Width) / 23.96, 0): Haut = Round((iPict.Height) / 23.96, 0)
If Larg >= Haut Then Set Shp = ActiveSheet.Shapes.AddPicture(Fichier, msoTrue, msoCTrue, 5, 5, 400, (Haut * 400) / Larg)
If Haut > Larg Then Set Shp = ActiveSheet.Shapes.AddPicture(Fichier, msoTrue, msoCTrue, 5, 5, (Larg * 400) / Haut, 400)
'Shp.Select: Shp.Cut: Sheets("Feuil2").Select: Cells(n, 1).Select: ActiveSheet.Paste: n = n + 1: Sheets("Feuil1").Select
Shp.Select: Shp.Cut: Sheets("Feuil2").Select: Cells(n, 1).Select
ActiveSheet.PasteSpecial Format:="Image (JPEG)", Link:=False, _
DisplayAsIcon:=False: n = n + 1
Sheets("Feuil1").Select
Set iPict = Nothing
Next
End Sub