Copy Image using VBA
Hi there,
I am trying to programatically copy a picture from one Excel worksheet
to another in a same workbook, but don't know how.
I found a piece of code from this newsgroup that shows how to copy a
picture from outside of the workbook, but not within.
Range("D2").Select
ActiveSheet.Pictures.Insert ("C:\Pic1")
Can someone please advice?
Thank you for your help!
Lin
|