View Single Post
  #6   Report Post  
Excel_Geek
 
Posts: n/a
Default


Are there more than one images you want to copy and paste? Try
something like this:

ActiveSheet.Shapes("Picture 1").Select
Selection.Copy
Sheets("(whatever the sheet is named)").Select
Range("(whatever cell it goes in...)").Select
ActiveSheet.Paste

"Picture 1" is by default what Excel/VBA will name the image. You can
find out if your logo is named something else by simply recording a
macro where you copy and paste the logo.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=397202