add function by VBA

**Gabi** · 06-18-2012, 01:58 AM

Hi
I tried to implement the tip from http://www.exceltip.com/show_tip/Cus...ction/147.html
And got syntax error .
What might be the problem?
I did the entire step by steps:
Build a module:

Please Login or Register  to view this content.

Saved it as xlsm
The function was build and can be operate in the excel sheet.
( And give the error )

**royUK** · 06-18-2012, 02:10 AM

The code doesn't seem to have a proper minus sign. It works for me when I edit it.

I can't really see the need for it though, you should be able to do this without VBA

**Gabi** · 06-18-2012, 02:22 AM

Thank U for this immediate reply.

Usually I did this function with names and formula. I am trying to use the VBA function.
How can I found this error by debugging?
( Visually I see no difference )

**royUK** · 06-18-2012, 08:24 AM

The only difference that i could find was the minus sign wasn't recognised. When I change it from my PC it was OK. It might be a difference in your font.

I would not use a UDF for this, use a manually entered formula.