Copy excel range as Bitmap in clipboard

[atuljadhavnetafim]

Hi Experts,

I have 30+ sheets that have some data which I need to copy and paste in PPT as a bitmap.
now every time I need to select range manually > copy > paste as bitmap in PPT.
if any changes in excel then again I need to copy that part again and paste it into PPT.
so what I need in the macro which copies range as a bitmap and then manually paste in PPT.
every sheet has a different range, please give me one sheet ("Actual Sales"). range("N3:Y37").
Please note: some rows will be hide which no need to copy, only display items should be a copy and stored in the clipboard.
then I will paste wherever I need to paste.
I tried the below code but it pastes excel as a table.

Sub copy_to_Clipboard()
Worksheets("Actual Sales").Range("N3:Y37").Copy
End Sub

Thanks in advance

 

[Domenic]

Try...

Worksheets("Actual Sales").Range("N3:Y37").CopyPicture Appearance:=xlScreen, Format:=xlBitmap

Hope this helps!

 

[atuljadhavnetafim]

Hi Domenic

it is working as expected, Thanks once again

 

[Domenic]

You're very welcome, cheers!