CODEWITHSUNDEEP
excelvba
Mohd Reza
Mohd Reza

Reputation: 73

Vba Copy a range and paste as a HIGH quality picture

Need a way to paste higher quality image

Hello everyone and thank you in advance for your time, I have a simple dashboard which copies a range of cells containing a table and a chart from another sheet and pastes it as a picture in the dashboard tab, it all works great except that the chart in the picture is VERY low quality and fine details are missing, is there a way to paste this at a higher resolution?

    Range("A1:O53").Select
    Selection.Copy
    Sheets("Dash").Select
    Range("A4").Select
    ActiveSheet.Pictures.Paste.Select

enter image description here

enter image description here

Upvotes: 1

Views: 2650

Answers (1)

iDevlop
iDevlop

Reputation: 25272

I think you might need to Copy Picture. Have a look here:
Excel Vba Copy Picture to new sheet
or try the recorder.
On my Excel 2019 it does even record a Copy instruction, but works anyway.
I have been using Copy Picture quite often when preparing PowerPoint, the quality is much better.

Upvotes: 1

Related Questions