I think you are calling the function incorrectly. I think you need to use the "worksheet functions" collection of the application object. Follow instructions here: http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx and follow the link to the list of worksheet functions available to visual basic. It appears that norm.s.dist function called from VBA uses underscores for the dots.