if or vlookup
 

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

if or vlookup
 

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


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 07:08:02 -0700, nivek05
wrote:

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

if or vlookup
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nivek05" wrote in message
...
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