.. I've placed the codes in my Sheet1 Code Box,
this is the sheet I'm using to test these codes,

Think UDFs are supposed to go into a regular module,
not the sheet module.

Try re-installing it:
Press Alt+F11 to go to VBE
Click Insert Module
Copy n paste the UDFs into the code window on the right
Press Alt+Q to get back to excel, and try it out

(You should also remove whatever you've installed into the sheet module)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---