Hello,
My macro takes the cell value (an image name) and uses it to import pictures into the worksheet. If there is no associated picture, I get "Unable to get the Insert property of the Picture class." I was wondering how to ignore, continue past this, or check if there is an image before executing
Here is the code snippet I have:
Dim picture Set picture = ActiveSheet.Pictures.Insert(ThisWorkbook.Path & "\Images\" & picname & ".jpg") picture.Select '...more code here that resizes image
Bookmarks