On error go to next find requirement

[LoneReaper]

Good Morning

I'm having difficulties getting an "on error go to next" clause working in my fairly simple code:

Please Login or Register  to view this content.

Essentially I want to find selected texts (that are headings) and copy and paste them over to the right and then delete what is not needed. However some of the above texts will not be available and therefore an error would occur. When the error occurs (if it does) I want it to move onto the next find selected text until all available ones have been found.

Hope this makes sense and hoping someone can assist with me, greatly appreciate it as always

[Norie]

Try this.

Please Login or Register  to view this content.

[humdingaling]

try this instead

Please Login or Register  to view this content.

ps you probably don't need after:activecell in the code since your using cells.find anyway

[LoneReaper]

Try this.

try this instead
ps you probably don't need after:activecell in the code since your using cells.find anyway

Thank you both. Both worked exactly as i needed to. Thanks for the thoughts as well Humdingaling on doubling up on code, definitely need to clean up on that.