Hi there,

Wondering if it is possible to convert a string into a numeric value. The idea is that if you have a list of names, if you could add up the numeric values of the names together and hide it at the end of the list. Then if a name on the list changes, then so will that value.

I know how to do this in C or Python, but I am rather new to the syntax of VBA.

Kind regards

Rob