Solved: Name #? error

[NiklasBech]

When i use my function called "Udregn" takes a Range, it works perfect when i do like this:
Cells(Celle.Row, SubA) = "{" & Udregn(Celle) & "}"

But when i try to use my function for dynamic purpose so it updates instead of being a string:
Cells(Celle.Row, SubA) = "=Udregn(Celle)"

I get a NAME!# fail and then a Value#! fail how to solve this ?

[shrivallabha]

Maybe if you could post a sample workbook with above UDF.

You may try following:
Cells(Celle.Row, SubA).FormulaArray = "=Udregn(Celle)"

[NiklasBech]

Im using a function like this Function Udregn(Cell As Range) As String, and my problem is everytime i type in a value "=udregn(xxx)" it reads xxx as xxx instead of what it represent for example "B4"...

[shrivallabha]

Im using a function like this Function Udregn(Cell As Range) As String, and my problem is everytime i type in a value "=udregn(xxx)" it reads xxx as xxx instead of what it represent for example "B4"...
If xxx is string variable then:
Cells(Celle.Row, SubA).Formula = "=Udregn(" & xxx & ")"

[NiklasBech]

THX A LOT SIR ;)