Excel Help

Soldato
Joined
17 Dec 2003
Posts
3,250
Location
Peterborough
Hi all,

I am in need of some help :D

Basically, I have a spreadsheet with numerous formulas, etc.. which I am fine with.

However, I am trying to figure out a way to overwrite a formula with plain text BUT the formula remains intact. So, if the plain text is deleted, the formula will then populate the cell.

I have had a quick play around in VB but struggling.

Does anyone have a VB script that could help?

Cheers
 
I think I am having one of those days :(

Tried but no luck. I changed the range to my cell range.

My formula is =IF(BD7:BD23="W","READY FOR CALCULATION",IF(BD7:BD23="Y","COMPLETE",IF(BD7:BD23="N","")))

If I type Yes, for example, then delete, yes, the cell is then blank
 
Back
Top Bottom