UDF's (called from a worksheet cell) can't do much except return values to the
cell that holds the formula.

Maybe you could use a formula based on A1 or use a subroutine of some sort???

"compound <" wrote:

Great day everybody.
I have a question to the Excel Gurus!

I have user defined function in the cell A1 (something like
=myfunction() ).
I would like to insert value in to cell A2 by running this function.
For example by running
ActiveSheet.Cells(2, 1) = 5

If I do that then I get an "Application-defined or object-defined
error".

Does anybody know how to get around this problem?

Any suggestions will be appreciated.
Thank you.
Compound

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson