User Defined Functions

G

Guest

I'm new to UDFs and want to be able to call one from within a spreadsheet.

I have hit Alt+F11 and input the code within the empty code window relating
to the workbook where I want to be able to access the UDF, but when I then
try and call the UDF in the workbook, I get an #NAME? error.

Can anyone tell me where I'm going wrong?
 
A

aidan.heritage

User Defined Function needs to be stored in a module - so insert a
module, then move your UDF into it - should resolve the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF - not always calculated 9
RE: How can I display a user name is Excel? 1
Office 2007 Compatibility Pack issue? 1
UDF Not Recognized 2
User Defined Function being called by changes to an independent workbook 13
Passed Arguments to a UDF 9
User Defined Function - actioned in unrelated WB 5
User Defined Functions 2

Top