Thanks Jhieminga
I've double checked it and removed the space but still cant get it to work?

?
Using Excel 2002 and it is an english version.
If I PM my email to you will you please send me an example spreadsheet and i'll copy and paste directly.
Thanks
Mike