That is absolutely perfect, it speeds up the search by about 10 seconds - which is quite a long time when you are staring at a screen! Many thanks.

As an aside, I'm trying to also put a
Rows(ActiveCell.Row).Select
in there after it has found the correct cell but it comes up with a 1004 error, I don't suppose you would also know where this would need to go?