Hi martindwilson

I have just checked and they are both saved as .xls and it is saved as 97 - 3003 workbook.

I dont understand why this formula just wont work as I have used it hundreds of times in my old 2003 version.