Hi
I have a signature in jpg format, which I am copying to two different places in the same sheet by using this code
Now I want to delete these two signatures only, by keeping one (let's say original) in tact
Please Login or Register to view this content.
I am trying with this but it throws an error
Please helpPlease Login or Register to view this content.
You cannot use a Shape object to iterate through a Range object.
Your method to duplicate the shapes results in duplicate names (I was surprised this was possible). The best practice would be to give them unique names when you create the duplicates.
Also note that this declaration
creates oShape1 as a Variant because there is no data type, and oshape2 as a Shape. You must give a data type for every variable.Please Login or Register to view this content.
The first Sub creates two duplicates. The second Sub deletes the duplicates, leaving the original.
Please Login or Register to view this content.
Hi there,
As Jeff correctly points out, it is surprising that Excel allows Shapes with identical names to exist on a single worksheet, but I guess that this is one of Excel's vagaries
Just to show that there is usually more than one way to skin a cat when using Excel, the following code will delete all but one of the Shapes which have the same name - the Shape allowed to remain is the one which is closest to the top of the worksheet:
Please Login or Register to view this content.
Hope this helps - I also hope that Jeff doesn't mind me jumping in here.
Regards,
Greg M
The more the merrier!Originally Posted by Greg M
Thanks a lot
It's working nicely
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi again,
Many thanks for your feedback - much appreciated!
You're welcome - glad I was able to help.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks