J
John Wirtr
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
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