I don't think it solves your problem.Where the user places the call to the UDF is where the data getsreturned. A UDF can't alter anything in the spreadsheet directly.