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
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