hi, i want to know how to search strings in excel ranges using vba and copying,and pasting them in other sheet