Excel Macro - Take a snapshot of Particular Range

Question

I have come around a very strange requirement in my Excel Dashboard.

I have a some data in a Range in a particular sheet. I need to take a snapshot of it and display it as an Image in all other sheets at top.

I know I can simply copy & paste the range but that kind of Header is creating some issues while hiding columns on the sheets.

Any solution/trick for that same?

Your question is very unspecific! What kind of "some issue"? Can you share a screenshot? — Peter Albert, Feb 20 '13 at 21:46

score 16 · Accepted Answer · answered Feb 20 '13 at 21:55

16

Range has a .CopyPicture method.

Or use the Camera tool:

Sub Tester() 
    Sheet1.Range("D5:E16").Copy 
    Sheet2.Activate
    Sheet2.Range("A1").Select 
    ActiveSheet.Pictures.Paste Link:=True 
    Application.CutCopyMode = False 
End Sub

answered Feb 20 '13 at 21:55

Tim Williams

154,628
8
97
125

Can this be used to paste the picture in email body drafted by excel? – urdearboy Jan 29 '19 at 14:37
I'd try the CopyPicture method for that – Tim Williams Jan 29 '19 at 15:52
@TimWilliams i'll give it a try. If I cant figure it out I may post a question and link it here! Thanks – urdearboy Jan 29 '19 at 15:59

Excel Macro - Take a snapshot of Particular Range

1 Answers1

Linked