In general:
ActiveSheet.Pictures.Insert( _
"C:\Documents and Settings\OgilvyTW\My Documents\My
Pictures\Sample.jpg"). _

so you could replace the argument with a cell reference


Range("B9").Select
Activesheet.Pictures.Insert Range("A2").Value

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Could you give me an example of how i would get the macro to pickup the
pathname and import the picture?

Thanks!