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

I have user defined function in the cell A1 (something lik
=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-define
error".

Does anybody know how to get around this problem?

Any suggestions will be appreciated.
Thank you.
Compoun

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