Function returning worksheet formula problem.

Please confirm on which cell you are applying the UDF?

Activecell refers to which cell?

Nope, a UDF called from a spreadsheet cell cannot do that. A Sub Procedure can do that kind of thing all day long, and if you tie it into a calculate event procedure, it can be executed with each calculate event.

Perhaps if you explain this in more detail and why you want to approach it this way, we can suggest some alternatives (like using the INDIRECT() or OFFSET() functions or something else).

I think maybe you wish to use named formula? You may define name (like 'test') that refers to formula like =$A$1*$B$1 and then in cells you may use =test. If you change formula in the name, cells will calculate this new formula.

Kind of a duplicate post by the same user (threads merged, so link removed)

As mentioned in the other thread, this is something a UDF called from a spreadsheet cell cannot do. I will certainly agree with you that formulas like that, with multiple parentheses and multiple levels of nesting and multiple conditions are difficult to work with (and I usually just don't have the patience to unravel them). You suggest that your concern is with the ability to "change" the formula. Can you explain in more detail what you need to do with this formula? How do you need to be able to change it?

Sort of a duplicate post. Here's the OP's original post with the full function that he is trying to work with http://www.excelforum.com/excel-prog...a-problem.html

frikost

Pls take some minutes and read Forum rules.

Don't post duplicated threads. For this time-as there are replies to both of then-i merged the threads.