Hi all,
Ive written a macro that selects all the data thats been entered e.g C2:F22, and then deletes the contents. Only trouble is, i dont know how to make a formula stay in a cell permenantly so that if the contents are deleted, the formula remains!
Anyone got a clue?
Scuzz
Ive written a macro that selects all the data thats been entered e.g C2:F22, and then deletes the contents. Only trouble is, i dont know how to make a formula stay in a cell permenantly so that if the contents are deleted, the formula remains!
Anyone got a clue?
Scuzz