Hi Scott,
The formula should work. However, make sure that the long lines are not
broken because of word wrap.

For instance the line starting with
If ...
has to continue till the then
You will know this kind or error (syntax error) if you see a line in red.
There may be some logical error but that will give you a wrong result though
the code will run. In your case the code is not running.

Alok




"Scott G" wrote:


My formula is =NameToSortOn(B1)
Column B contains the name of the addressee. Do I need to add to the
formula?