Created attachment 119164 [details] Testfile with Range function I have a Function like this Public Function Oszt(x as Integer) as Range It give me back a Range. (The Functions with one Cell return value hasn't any problem.) It works me only one time. The Calc doesn't refresh the output, if I change the input Cell. If I have more than 1 row with input and Functions, the Calc give me the first output many times. I seted a breakpoit in to my Basic code. the code runs, and make the correct output, but this output doesn't arrive to the Cells. The Calc Cells become old numbers.
Sorry it is my fault. The Function should be return as Variant. Public Function Oszt(x as Integer) as Variant If it is so defined, than it works fine.
(In reply to Zsolt from comment #1) > Sorry it is my fault. The Function should be return as Variant. > > Public Function Oszt(x as Integer) as Variant > > If it is so defined, than it works fine. Closing