A UDF cannot change anything in a workbook.

If that is not an answer to your question; what is the code of your UDF and what are the values of the cells involved?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"pinkfloydfan" wrote in message oups.com...
| Hi there
|
| Can anybody explain why I have this particular problem?
|
| I have written a UDF that outputs a 2-dimensional array. If this UDF is
| called F(x) why does the following give a #N/A error?
|
| MATCH(X6,F(x))
|
| If I can't find a way to make this work then I guess I'll have to write
| a UDF of my own to solve the problem.
|
| Cheers.
|