User Defined Functions

M

Mike McLellan

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's & puzzling recalculation behavior 3
UDF - not always calculated 9
UDF from Add-In returning #NAME 0
excel spreadsheet functions written in vba 1
using defined name in UDF 11
User Defined Function being called by changes to an independent workbook 13
Passed Arguments to a UDF 9
Setting a default zoom in Infopath 0

Top