Problem with assigning value from UDF to a cell

Hi, Here is my requirement.

I have multiple stock price worksheets. I need to assign a value to one of the cells from a UDF and then assign it to other cells below that. Here is the code that I have but keep running into a run-tiem error "424". "Object Required". I am not able to understand what the issue is. The UDF works correctly when I used it directly in the worksheet

Please Login or Register  to view this content.

priceroc here is the UDF

Any help would be appreciated

Originally Posted by JBeaucaire

Try this instead:

Please Login or Register  to view this content.

It would be easier to test alternate ideas if you posted a workbook with the UDF installed.

Thanks Jerry. That was partially helpful. Is it possible to change the R2C5 (the second parm) to not be constant. For e.g. in this case, the cell G12 would have priceroc($e12, $e$2)
The cell g13 would have priceroc($e13, $e$2).. I want $e$3 or $e3 instead of $e$2 in this case

Thanks Again!!