if or vlookup

[nivek05]

Hi I wish to put a logo on say sheet one stored from sheet 2 using an if
statement,
I have looked at http://www.mcgimpsey.com/excel/lookuppics.html
but it doesnt seem to work for me is anyone able to give me a dumbed down
version of it?

any help apreciated.

Kevin Z

 

[Gord Dibben]

You must have the images stored on the same worksheet when using John's code.


Gord Dibben MS Excel MVP

 

[Don Guillett]

Sub copyshape()
With Sheets("sheet14")
..Select
ActiveSheet.Shapes("myshp").Copy
Application.Goto Sheets("sheet13").Range("b12")
ActiveSheet.Paste
End With
End Sub