I have used code to insert a picture (Bracket.jpg) into a cell range (B38:I51).
The picture file name varies but the insert range remains the same. In one case Excel notes the inserted picture as "Picture17" and another case as "Picture5"!
What would be the code to remove the inserted picture?
Thanks Sandy
If you have no other images on the sheet that you want to keep you could use
Please Login or Register to view this content.
You could also look for the picture whose top and left were the same as the insert range top and left
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
You might also give the picture a specific name when you insert it, which would make deleting it a trivial task.
Don
Please remember to mark your thread 'Solved' when appropriate.
I suggest you go with xlnitwit's idea and name it properly on inserting. Fix problems at the root rather than at the other end !
Show us the code if you have any concerns with doing that.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Thanks Guys.
The picture is selected from a combobox (cmbBrack) in a userform, and on exit the following code runs:
Then this code adds the picture to range B38:I51:Please Login or Register to view this content.
Unsure how to proceed now, sample code would help.Please Login or Register to view this content.
I presume in the "with p" section just add
iePlease Login or Register to view this content.
then obviously refer to it by name in any future code.Please Login or Register to view this content.
Thanks scottiex that worked a treat.
Cheers Sandy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks