Hello George,

A User Defined Function can only return a value that will be displayed
in the cell the UDF is in. You can not change the values of others
cells or their formats in a UDF. Calling a macro to chage a cell's
value or format from the UDF won't work either.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=513741