Hi Nigel, thanks so much for the code - greatly appreciated. It does
work if I use numbers only for the File Reference Number in column A.
When I enter text such as "FTAN52147" it does not work for some reason.
Could you please modify your code so that it works for string data?

Thanks,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***