What you're after is not possible via formulas.
Hang around awhile for insights from others
versed in vba.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dannycol" wrote:
Thanks for the suggestion but it does not seem to solve
my query unless i've miss understood!

In B6 i have formula IF(A60,"Sale","") This works fine.. periodically i
have to delete the word 'Sale' leaving B6 blank which also deletes the
original formula... I'm trying to re input the original formula into B6, so
once i delete the word Sale (or delete what ever data is in B6) the formula
IF(A60,"Sale","") is restored in B6?

Would it be possible?

Regards

Danny