I am trying to assign a user defined VB function to excel cell.
I wrote a s simple function called testy() in VB editor that returned a number.
Function testy() As Single
testy = 2.4
But when I assign excel with thus function like this,
I get a cell error #NAME?
What I am doing wrong.