View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default UDF returns #NAME? error

Mike,
=TheTest rather than =TheList?

"mikebres" wrote:

When I create my own function and place it in a cell I get a #NAME? error.
To test this further I created the simple function below. I entered
=TheList() in a cell. I still got the error. Any ideas why, or better yet
how do I fix it? Thanks - Mike

Function TheTest()
TheTest = "Hello"
End Function