I have an excel work sheet where certain condition is tested when an input is performed on an active cell. If the condition tests as true, the content of the active cell should be returned to null. I have tried to use an excel formula to assign '=""' to the active cell but it holds that you cannot assign a value to a cell reference. i.e. to say =AC1="".
The result of the above would alsways be false, with the active cell, because excel would think you are trying to compare the content of the referenced cell to the null status, which would result in false.
I would be glad if someone helps out. Anybody?
Might be a VBA solution.