Thread: copying cells and pasting them as linked picture

hi there,

I have looked around like crazy and still cannot pull this one off...

I am trying to paste a range in a different worksheet as a picture, but linked to the source, so that it will change when users update it

I know how to do that by hand, but I need a macro to do it for me
could somebody please give me a hand?

thanks!!

well, since I found the way to do it I'll post it here for anyone interested, or in case I forget and search the net again for the solution

Private Sub CommandButton2_Click()
    Worksheets("Sheet1").Range("C1:C5").Copy
    ActiveSheet.Pictures.Paste link:=True
End Sub

is quite bizarre that it does not work if you use copypicture but I guess then it becomes impossible to link it to data --- anyway, a remark in the excel help would be awesome