Move or copy pictures between worksheets

  • Thread starter Thread starter Tom Meacham
  • Start date Start date
T

Tom Meacham

How do I or can I insert a picture into one worksheet and then have another
worksheet copy over that picture. I tried just using = "the cell with the
picture" but that does not work. Thanks for the help!
 
Hi

Select the cells around your picture
Edit >Copy
Go to the other Sheet
Shift>Edit..Past picture Link
If yo change the picture in the first sheet the others will also change


Maybe you like this

Sub test()
On Error Resume Next
Set pic = ActiveSheet.Pictures.Insert("C:\range.gif")
On Error GoTo 0
If Not pic Is Nothing Then 'The picture exists
Set rng = Range("a3") ' or ActiveCell
With pic
' .Height = rng.Height
' .Width = rng.Width
.Left = rng.Left
.Top = rng.Top
End With
End If
End Sub

You can loop through your sheets and add the same picture in all sheets
 
Back
Top