I have been creating lists to make pull down lists in my worksheet. Almost
all have worked fine but with one list I keep getting the message that the
Source evaluates to an error.

What does this mean and how can I troubleshoot this?

I have tried retyping the list, moving the list to a different column and
renaming the list.

Are you using a formula to give the source of the list a defined name?

--
Biff
Microsoft Excel MVP


"Periwinkle" wrote in message
...
I have been creating lists to make pull down lists in my worksheet. Almost
all have worked fine but with one list I keep getting the message that the
Source evaluates to an error.

What does this mean and how can I troubleshoot this?

I have tried retyping the list, moving the list to a different column and
renaming the list.