#Name error for VBA function

[William Ladd]

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 Insert>Formulas 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.

 

[William Ladd]

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!