ilia wrote:
An in-cell UDF (or any worksheet function for that matter) can only
modify the value of the cell from which it is called. It cannot
modify font, number format, or values of other cells.

If your analysis needs to put results in other cells, you can either
have a UDF that returns an array, or a Sub that populates cells where
you want the analysis.

Or a Sub procedure that calls the UDF that populates the cells.

Alan Beban