Hide #VALUE! - Is it possible?

[CasperA]

Is it possible in hide the display of the characters #VALUE! in those cells that do not yet display the result of a formula?

CA

 

[jorismoerings]

Hi,

If you're nesting formulas, you need to remove the =

so your formula =(A1) nested with the iferror function becomes =IFERROR(A1,"")

 

[MARK858]

Hi jorismoerings, the OP isn't in reality using the formula =A1, they are using the UDF Reconfig (see post #15 but the UDF should actually look like the UDF below (at least it should if it doesn't turn out to be better to change the UDF when the OP actually states what causes the error/s))

Function Reconfig(S As String)
    Dim V As Variant, i As Long
    V = Split(S, " ")
    For i = 1 To UBound(V) + 1
        Reconfig = Reconfig & i & "• " & V(i - 1) & " "
    Next i
End Function

 

[CasperA]

Hi,

If you're nesting formulas, you need to remove the =

so your formula =(A1) nested with the iferror function becomes =IFERROR(A1,"")

Thank you, jorismoerings, I learned something about nesting formulas.

Best,
CasperA

 

[CasperA]

Hi jorismoerings, the OP isn't in reality using the formula =A1, they are using the UDF Reconfig (see post #15 but the UDF should actually look like the UDF below (at least it should if it doesn't turn out to be better to change the UDF when the OP actually states what causes the error/s))

Function Reconfig(S As String)
    Dim V As Variant, i As Long
    V = Split(S, " ")
    For i = 1 To UBound(V) + 1
        Reconfig = Reconfig & i & "• " & V(i - 1) & " "
    Next i
End Function

I will try and find the spreadsheet where the error occurred so that I can state more precisely what caused the error.

CasperA