Apologies,
I didn't look carefully enough at your query. I see now what you mean. I
would repost this in 'Programming', The VB experts are there although I'm
not sure this can be done directly in code, it may have to refer to a
worksheet formula, I'll look forward to the answers, Good Luck,
Regards,
Alan.
"shternm" wrote in
message ...

That doesn't work either.

Just so I am making myself clear: I don't want to see the formula in
the cell just a result (value).


--
shternm
------------------------------------------------------------------------
shternm's Profile:
http://www.excelforum.com/member.php...nfo&userid=858
View this thread: http://www.excelforum.com/showthread...hreadid=486065