Hi

How about an example workbook.

As an aside, a function should not be used to put a value into a cell. It should return a result in the cell where the function resides. If you want to actively populate a value into a cell, then you should use a sub.

rylo