Fantastic Donkey, cheers!!!
I'm an idiot btw :S
I had copied the UDF into a module on a different spreadsheet :D
and the worksheet wasn't named Sheet1.
Its working perfectly now, thanks very much!