Lee wrote...
I have an excel spreadsheet that was sent to me that contain functions that I
do not recognize - e.g. EVAPP EVGTS, etc. I get an #NAME? error i these cells.
Does anyone know what these are? I'm guessing some kind of use defined
functions.
They're almost certainly user-defined or add-in functions. If they'r
implemented in a commercial product, i.e., one you'd have to pay t
use, then the only way you could use this workbook would be for th
person who sent it to you to convert all formulas containing thes
formulas to values or you'd have to buy the add-in yourself.
With regard to converting all formulas containing these functions t
values, a simple macro may suffice.
Sub foo()
Dim ws As Worksheet, c As Range, fn As Variant, fa As Variant
Dim p As Long, cf As String
fa = Array("EVAPP", "EVGTS") 'etc.
For Each ws In ActiveWorkbook.Worksheets
For Each c In ws.UsedRange
If c.HasFormula Then
cf = c.Formula
For Each fn In fa
p = InStr(2, cf, fn & "(", vbTextCompare)
If p > 1 And Mid(cf, IIf(p > 1, p - 1, 1), 1) Lik
"[-+*/^=(,]" Then
c.Value = c.Value
Exit For
End If
Next fn
End If
Next c
Next ws
End Su
