#Name error for VBA function

  • Thread starter Thread starter William Ladd
  • Start date Start date
W

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.
 
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! :)
 
Back
Top