#NAME trying to find VB function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys. I'm new to excel programming and I wrote a macro by Alt-F11. Now
when I access it from the worksheet I get a #NAME exception. This worksheet
is the 4th worksheet in the workbook if that matters.

In the editor in the obect dropdown list it says (General) and in the
procedure drop-down list it says the name of my function. The procedure
shows up when I select (General) or Worksheet in the object dropdown.

Do I have to enable VB or something?
 
Sounds like it is in a sheet module.

Go to the VBE and do Insert=>Module

move your code to this module.
 
Back
Top