Sub CopieEcranSaisie_PNG()
Dim Gr As Object, Rg As Range, R$, N$, C$, PathFich$
R$ = "A1:R99"
N$=Format(Date,"dd_mm_yyyy")
C$ = ActiveWorkbook.Path & "\"
Application.ScreenUpdating = False
PathFich$ = C$ & N$ & ".jpg"
Set Rg = ActiveSheet.Range(R$): Rg.CopyPicture xlScreen, xlPicture: DoEvents
Set Gr = ActiveSheet.ChartObjects.Add(0, 0, Rg.Width, Rg.Height): DoEvents
Gr.Activate: ActiveChart.Paste: DoEvents
Gr.Chart.Export PathFich, "jpg": DoEvents
Gr.Delete: Set Gr = Nothing
Application.ScreenUpdating = True
M$ = "copie écran sauvegardée:" & vbLf & PathFich$
MsgBox M$
End Sub