#NAME? error

**RobinClay** · 11-18-2011, 12:55 PM

Well ! It worked just FINE yesterday !

It's a simple little thing:-

.........G............................H
16......Height.......................54
17......Width......................110
18.......Area.....................5940...............Formula is =H16*H17
19....Perimeter...................328...............Formula is =H16+H16+H17+H17
20..Equiv diameter.......#NAME?...........Formula is =2*RadFromArea(H18)

AND then I have the UDF:-

Public Function RadFromArea(Area As Double) As Double
RadFromArea = Sqr(Area / Pi)
End Function

So - erm - why does it not work ???

It doesn't even TRY to run the UDF, which compiled OK

ALL the other similar UDFs work fine...

**davegugg** · 11-18-2011, 02:18 PM

Why build a UDF when Excel has functions that can handle that:

=2*SQRT(H18/PI())

**Paul** · 11-18-2011, 02:23 PM

If you must use your UDF, change it to:

Public Function RadFromArea(Area As Double) As Double
RadFromArea = Sqr(Area / WorksheetFunction.Pi)
End Function

**RobinClay** · 11-18-2011, 07:15 PM

Thank you both - but neither answers the question.

Sorry - I forgot to mention that I have already defined Pi as a constant elsewhere.

Excel doesn't even try to run the UDF, so it matters not what is there. It does compile OK.

WHY does it not run.... Yet it did yesterday !

**shg** · 11-18-2011, 07:20 PM

Works fine for me.

Where is the code? It has to be in a standard module in the workbook where the formulas appear, or in a workbook referenced by the workbook with the formulas.

EDIT: And macros have to be enabled.

**RobinClay** · 11-18-2011, 07:53 PM

Thank you also for that response.

It gets worse !

That formula appears in two other places, and works fine, and in two more where it also doesn't work !

If I copy one of the workingones, it works. If I copy a non-working one, it doesn't.

So I copied a working one into that slot, and Voila ! It works !

It's a mystery....

Oh - the routine is in an add-in Library with several hundred UDFs - and, yes, micros are enabled, and the add-in is referenced. And it works elsewhere !?!?!?!