View Full Version : Solved: Name #? error
NiklasBech
03-31-2013, 06:40 AM
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
03-31-2013, 09:04 AM
Maybe if you could post a sample workbook with above UDF.
You may try following:
Cells(Celle.Row, SubA).FormulaArray = "=Udregn(Celle)"
NiklasBech
03-31-2013, 12:22 PM
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
04-01-2013, 07:29 AM
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
04-01-2013, 12:55 PM
THX A LOT SIR ;)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.