#NAME trying to find VB function?
 

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?

#NAME trying to find VB function?
 

Sounds like it is in a sheet module.

Go to the VBE and do Insert=Module

move your code to this module.

--
Regards,
Tom Ogilvy



"fedude" wrote:

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?

#NAME trying to find VB function?
 

Thank you. That fixed it!

"fedude" wrote:

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?