Hi,

I'm trying to be able to clear the contents of a cell by simply deleting them, but I don't want the formula assigned to that cell to delete. I tried to use VBA to assign the value of the cell to the result of a formula, but I keep getting a run time error 6, overflow.

Any suggestions would be great.

Mickie