Is UDF volatile or formulas?

[ljubo_gr]

Hello dear MrExcel,

Is this formula volatile:


=IF(ISNUMBER(SUBSTITUTE(LEFT(SUBSTITUTE(REPLACE(B33;1;AGGREGATE(15;6;FIND({0\1\2\3\4\5\6\7\8\9};B33;FIND(" ";B33;SEARCH("cmr:";B33)+5));1)-1;"");" ";REPT(" ";20));20);".";"")+0);SUBSTITUTE(LEFT(SUBSTITUTE(REPLACE(B33;1;AGGREGATE(15;6;FIND({0\1\2\3\4\5\6\7\8\9};B33;FIND(" ";B33;SEARCH("cmr:";B33)+5));1)-1;"");" ";REPT(" ";20));20);".";"")+0;0)

=SUMPRODUCT(('sheet1'!$D$8:$D$1440<>"inventura")*('sheet1'!$D$8:$D$1440<>"pretakanje")*MMULT(--('sheet1'!$E$8:$L$1440=List!D33);{1;1;1;1;1;1;1;1}))>0

Or this UDF:

Function LastNumber(G As String) As Variant
  Dim X As Long, Num As Long, Words() As String
  Words = Split(G)
  LastNumber = ""
  For X = UBound(Words) To 0 Step -1
    Words(X) = Replace(Replace(Words(X), ".", ""), ",", ".")
    If Replace(Words(X), "-", "") & " " Like "[Ss][5-14][!0-9]*" Or Replace(Words(X), "-", "") Like "[Ss]1[0-2]*" Then
      LastNumber = ""
      Exit Function
    ElseIf Val(Words(X)) <> 0 Then
      LastNumber = Val(Words(X))
      Exit Function
    End If
  Next
End Function

Thanks!

 

[ljubo_gr]

Strange. It was FORMULATEXT()
I had this formula in cell G3 to G752 =IF(A3=TRUE;"";FORMULATEXT(B3))
Thank You Rory Barry Joe, God Bless You
Thank you for great MrExcel!