Need a macro to search for a specific list of words and run an other macro if found

[kmc1234]

I have been very puzzled with this one.

I am looking to create a macro that will search my spreadsheet for specific list of words. If any of these words exist I would like to excecute a second (wordart) macro.

I would like the macro to execute each time the file is closed, so that if the found words are removed then the wordart is also removed.

Does anyone have any ideas on the best way to do this?

Many thanks..

 

[karthy]

You can perhaps try this.
Sub replace()


Sheets("xyz").Select
For Each c In Range("A1:J650")
If c.Text = "your search string " Then
Your function
Next c
End Sub

and for the second function you asked, you can begin your coding with
Sub Workbook_BeforeClose(cancel As Boolean)

 

[Oeldere]

Without an macro,

CTRL + H

find

replace