The problem is that if this macro is run more than once it creates a second OLEObect on top of the first. If it could start at the first hidden row that would probably solve the problem. Alternately, if it could be made to check for the presence of an OLEobject and only insert the new one if there isn't already one there, that would definately work. thanks in advance for any advice!
Please Login or Register to view this content.
hi Wilardio, you can add the following line to your code:
Please Login or Register to view this content.
Thanks Watersev, but the macro may have been previously run, which would change the count and make the macro shut down. I guess what I'm looking for is something that will check the specific cell where the oleobject is about to be added, and then only add it if it isn't already there. Then I would need the "Next" to run and continue checking and adding objects (where they aren't already present) down to the end of the sheet.
Last edited by Willardio; 10-27-2012 at 05:38 PM.
maybe sort of this then:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks