Marc,

Actually that won't work at all. I was missing a beat when I suggested it,
because a worksheet function cannot modify it's environment, not setting
cell attributes (such as comments) or worksheet/workbook attributes (such as
names).

You could always use worksheet events, but it would depend upon what and how
your function works.

Apologies for that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Your comment storage solution sounds like it might work. Two
questions:
How do I find out the cell address from which the function is being
called?
and How do I store/retrieve the value in a cell comment?

Thanks,
Marc