Rookie Needs help

C

Curt

Can anyone tell me how to write a formula that will make a
cell self delete after a given time?
 
N

Norman Harker

Hi Curt!

As Peo says, this is a no can do for any formula or function.

The best you can do by formula is to modify the return of your formula
using something like:

=IF(TODAY()>--"2004-04-01","",Yourformula)

VBA may be an option but it might be best to look at why you want to
do it first.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
Top