Excel Help

[mad_allan]

Hi all,

I am in need of some help

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

 

[mad_allan]

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

 

[mad_allan]

Absolute legend, thank you!

A friend had to add a customer function command and bingo!