Help: iserror in VBA

[Kingnight]

Hey,

I am trying to do a very easy user-defined function. I am trying to check if errors in one cell, returns black, otherwise returns what is in the cell.

Here is my formula:

Function errors(anything As Variant) As Variant

If IsError(anything) Then

errors = ""

Else

errors = anything

End If

End Function

But it does not work.... Is there anyone who could tell where it is wrong. I greatly appreciate it.

 

[Jonmo1]

Works for me, in what way does it not work for you?

Are you expecting it to remove the error from the original cell (anything) ?
It will not do that.
A UDF cannot modify the values of OTHER cells, it can only return a value to the cell the function is entered in.

All it does is return blank if the reference is an error, otherwise returns the value of the reference.

 

[Kingnight]

Works for me, in what way does it not work for you?

Are you expecting it to remove the error from the original cell (anything) ?
It will not do that.
A UDF cannot modify the values of OTHER cells, it can only return a value to the cell the function is entered in.

All it does is return blank if the reference is an error, otherwise returns the value of the reference.

Thanks! Here is exactly what I want to do.

Here is data:
1 11 (it has own formulas)
2 GG (it has own formulas)
3 #value (it has own formulas)

If cell = #value, it will return blank, otherwise use what is in the cells.

My forumas does not work...:confused