Hi,
If, for example, I have a function that is used in a report template
and that needs to do some processing on the date.
processDate(A1) where A1 contains the NOW() excel function.
I have to questions :
- I want the result of processDate() to be automatically recalculate
when the user press F9, is volatil the good way to do?
- When Excel refresh its data, will it refresh the NOW() cell before
the processDate cell because if not, the result of processDate could be
wrong?
Thanks
Nic
--
nicgendron
------------------------------------------------------------------------
nicgendron's Profile:
http://www.excelforum.com/member.php...o&userid=25151
View this thread:
http://www.excelforum.com/showthread...hreadid=396201