You can only replace the cell contents with a macro. You could create a
formula in another cell to evaluate to the desired value.

steve

p.s.
Please reply to the sent messages so that each message contains all the
previous messages. Otherwise it is difficult to follow the train.

"Chee-wooi Ten" wrote in message
...
Can it be done without writing a macro?

Regards,
cw

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!