Is there any way to use that code in a User Defined Function.
I don't think it is possible in a cell formula.
how about Worksheet_Change or Worksheet_Calculate?

http://msdn.microsoft.com/library/en...HV05199719.asp
http://msdn.microsoft.com/library/en...HV05199619.asp

--
HTH,
okaizawa

HA wrote:
Hi,

Thanks for the code. I have one more question.

Is there any way to use that code in a User Defined Function.

thanks in advance...