'runtime error 1004 application-defined or object-defined error' when trying to input UDF through range.formula

Question

I'm trying to put a user defined function in cell J3 through Range.Formula method, but I encounter application-defined or object-defined error, can someone please tell me if it is even possible to put UDFs in cells that way? I tested the function by inputing it manually and it works. The code is:

Range("J3").Formula = "=EmpiricalDist($AF$1;$AD$1;0.95;E3;1;-1)"

where EmpiricalDist is the mentioned UDF. I'm working in excel 2013.

Range("J3").Formula = "=EmpiricalDist($AF$1;$AD$1;0.95;E3;1;-1)" — Sorceri, May 04 '15 at 20:27
@Sorceri Sorry, your answer was the code I used from the beginning, I was trying to put it as a string in cell J3, without the .Formula suffix, but it gave the same error — VBAEnthusiast, May 04 '15 at 20:28
The ; are what cause the error but without seeing your EmpiricalDist function I dont know what it is you are trying to do. — Sorceri, May 04 '15 at 20:36
@Sorceri thanks, replacing the semicolons with commas solved the issue — VBAEnthusiast, May 04 '15 at 20:58

score 0 · Answer 1 · answered Aug 10 '16 at 11:52

0

I had the same problem.

Chang line

Range("J3").Formula = "=EmpiricalDist($AF$1;$AD$1;0.95;E3;1;-1)"

Into

Use Range("J3").FormulaLocal = "=EmpiricalDist($AF$1;$AD$1;0.95;E3;1;-1)"

answered Aug 10 '16 at 11:52

Gerrit-Jan

59
1
9

'runtime error 1004 application-defined or object-defined error' when trying to input UDF through range.formula

1 Answers1