How do I create a macro that will go to sheet1 of my workbook and look at the location of a picture in Cell A1, and then insert the picture in Sheet 2 Cell A2?
I created the following macro by recording for inserting a picture but i am unable to change the code to do what i want.
"P:\Project_Files\Kentucky\KY14-041_KYTC_LaurelBA_11-1080\Images\Chelsey Pics 7-11-14\DSC00008.jpg" _
Selection.ShapeRange.Width = 233.28
Seems like you can put the sheet1.range("A1") into the file location above but it does not work.