Sub Range_To_Image()
Dim ObjChrt As Chart
Dim RngImage As Range
Dim strFile As String
On Error GoTo ErrExit
With ActiveSheet
Set RngImage = .Range("A1:L150")
RngImage.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
strFile = "C:\Users\TOTO\Desktop\Plage.jpg"
Set ObjChrt = .ChartObjects.Add(RngImage.Left, RngImage.Top, RngImage.Width, RngImage.Height).Chart
With ObjChrt
.Parent.Activate
.ChartArea.Format.Line.Visible = msoFalse
.Paste
.Export strFile
.Parent.Delete
End With
End With
ErrExit:
Set ObjChrt = Nothing
Set RngImage = Nothing
End Sub