Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined function gives #NAME?
I've writtena User Defined Function that yields #NAME? when I use it in a
spread sheet. Why is this? The code for the function is below. The code is in a module in PERSONAL.xls. I have also tried it in a module in the workbook where it is used. Same result. This UDF used to work for me. What am I doing wrong? John Wirt Function SigTest(cell1, cell2, cell3, cell4) Dim testval As Long testval = (cell1 - cell2) * (cell1 - cell2) testval = testval / (cell3 * cell3 + cell4 * cell4) If testval 3.841447 Then SigTest = "*" Else SigTest = "" End If End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Function | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |