Searching non consecutive or contiguous words

I am currently using a macro to search all sheets within an Excel file. The limitation I was hoping to overcome is the fact that the search only returns results if the words are in consecutive order ie red white blue will only match to red white blue in that order and not return results of white blue red. Kind of how Google will let you search without being 100% accurate on the order of words.

Is there any way around this? Very many thanks for any help!

Using Excel 2003 with the following code:

Please Login or Register  to view this content.