I am also trying to use the .find method and running into problems. Seems to work on Windows fine, but will not work on Mac. It doesn't seem as if the libraries on the mac have this built in. Am I missing something? Is there another way to use some sort of VBA .find method to search through a range of cells and assigning the fund value to a variable or the offset to the found value to that variable