how do I make this code start at the first hidden row in the sheet?

[Willardio]

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.

[watersev]

hi Wilardio, you can add the following line to your code:

Please Login or Register  to view this content.

[Willardio]

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.

[watersev]

maybe sort of this then:

Please Login or Register  to view this content.