#Name error for VBA function
 

I keep getting a #Name error for a VBA function that I have created. I have
even made the function so simple that it just returns 1 and I still get the
error. I'm selecting it from the InsertFormulas Section and it does show
up under User Defined functions. It is a general function as well. I'm
running a networked version of Excel 97. Any help at all would be
appreciated. Thanks in advance.

Bill Ladd.

#Name error for VBA function
 

Well, I found my problem. I was creating my function as a Microsoft Excel
Object under sheet1. Once I created a new module and put the code there
everything ran fine. Sorry for taking up the space - hopefully this will
help other similarly clueless VBA programmers! :)

"William Ladd" wrote in message
...
I keep getting a #Name error for a VBA function that I have created. I
have
even made the function so simple that it just returns 1 and I still get
the
error. I'm selecting it from the InsertFormulas Section and it does show
up under User Defined functions. It is a general function as well. I'm
running a networked version of Excel 97. Any help at all would be
appreciated. Thanks in advance.

Bill Ladd.