Search for partial value

Hi

I have a copy and paste macro that works fine for searching for whole but I want it to search for a partial value Eg. Total for Nick. I have added a star to the end of the search word but its not working for me. Any ideas?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Give this a go?

Please Login or Register  to view this content.