I have a workbook that houses a large macro that I would like to copy a picture from and place on a sheet in a new workbook. I don't have any issues with the VBA code in going back and forth between the worksheets. My problem is referring to the actual picture. Since the pictures "floats" on top of the cells, I can't hardly refer to the location (ie: Range("A1").Select). How can I refer to the picture?
BTW, currently, the code is pulling the picture from a location on our network--which works fine--but, i want to be able to copy this picture correctly without having to access the network. Thanks!
Something like this perhaps:
Code:Workbooks("Book2").Sheets("NewBook").Shapes("picture 1").Copy Workbooks("book3").Sheets("Sheet1").Range("h1").PasteSpecial
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks