Copy/Paste picture

[jyokom]

Is there a way to copy and then paste a picture in a specific place on a worksheet without telling it to paste into a specific cell? i.e using coordinates, etc.

 

[Ivan F Moala]

Is there a way to copy and then paste a picture in a specific place on a worksheet without telling it to paste into a specific cell? i.e using coordinates, etc.

Can you explain more please ?
What coordinates ?

 

[mae0429]

I think they're trying to avoid making the cell the size of the picture (or vice versa). He or she wants a general location to put the picture overlaying(?) the sheet. Or I could have that dead-wrong...

 

[jyokom]

Yes that is pretty much what I am looking for. I have the folowing code:
Private Sub Cbo_PP1_Change()
Range("AK28").Formula = "=VLOOKUP(AG28,Data!O111:Q115,3)"
If Range("AG28") = ("463L Pallet") Then
Sheets("Equipment").Shapes("Pallet").CopyPicture
Sheets("FormF").Range("PalPos1").Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 7#
Selection.Name = "pos1"
End If
End Sub
The picture "Pallet" is being pasted using cell selection ("PalPos") and then nudged left. This works, but I would like it to run cleaner than this and paste in a specific location that isn't exactly the top left corner of any cells in the area.