copying cells and pasting them as linked picture

[bagullo]

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!!