View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] linyang610@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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