Function works but I get a run time error 13.

Hi,

This is a function to add the ascii values of a string to give a single value. Initially I wrote this as a Sub routine and it worked fine, but when making it into a function, I get this error. From a little research it appears that you can not use a string as an arguement for a function call, yet that defeats the object of this particular function.

The intention of this function is that it works on a name in a given cell and the value (an integar) that is produced is then displayed in another cell, or if using it as a formula, the cell the formula is in.

I simple wrote the work "Hello" in cell A1 the ascii values of these added ignoring any spaces give 500 which is correct.

Please Login or Register  to view this content.

Any help would be appreciated

Rob

Thank you Norie, that is excellent, I actually came up with this after discovering the debug command, it's almost identical, but it is good to get verification.

Please Login or Register  to view this content.