I got an assignment to search in a certain excel worksheet which I'm using the Find & Replace dialog of excel all I want is to make a VB6 program that will going to load the excel data into VB6 flexgrid and search hundred of words in a one click only because it compose also of hundreds keyword to be search, because if I'm going to do this in Excel only I have to put one-by-one all the keyword in the Find & Replace dialog which give me a long hours to do that, any possible recommendation is highly appreciated thank you..

You want to search for all hundred at once or in a loop ?