generating a #VALUE

[Guest]

I have a UDF which, if it can't find what it's looking for, I want to return
and show #VALUE in the cell. Any ideas how do I do this? Thanks.

 

[Chip Pearson]

Use the CVErr function to create an Error type Variant and return that as
the result of the function.

Function Whatever() As Variant
If Something Then
Whatever = CVErr(xlErrValue)
End If
End Function


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

One way might be to trying adding a number and a letter..

Function Test()
Test = 1 + "a"
End Function

 

[Dave Peterson]

Have your function return a variant

Function myFunc(arg1 as ...) as Variant
'some code here
myFunc = CVErr(xlErrValue)
end function

 

[Guest]

forcing an error in excel will give the results. This worked for me

Function test(target As Range)

test.Value2 = "Error 2015"
End Function