Change search and highlight macro to two macros

[lsmcal1984]

Dear all,

Thanks for your help on this forum so far!

I am using the code below to highlight and search for text in Excel. It works great but it would be better if I could split into two macros – one for search and highlight, and the other to clear all highlighting.

Please Login or Register  to view this content.

Does anybody know how I could split this code into ‘Search and Highlight’ and ‘Clear Highlighting’ macros?

Thanks!

[lsmcal1984]

Solved with:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[arlu1201]

Welcome to the forum.

I have added code tags to your posts. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.