Need a Conditional Formula

[santanuKD]

Hello,

I need a formula that as soon as I delete a cell the value to be automatically changed to '0'.
Please suggest

Thanks,
Shan

[arlu1201]

Which cell will be deleted? You want the same cell which is deleted to be changed to 0?

[santanuKD]

Yes, thats the trick

[arlu1201]

Right click on your sheet name and select "View Code". Then copy this code in the code window that appears -

Please Login or Register  to view this content.

Then test it.

[santanuKD]

thats great .. cant we do that with a formula
anyway this solves .. many thanks

[arlu1201]

I am not sure if you can do it with a formula.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

[santanuKD]

Hi arlette,

How can we do this for a specific range

Thanks,
Shan

[arlu1201]

Do you mean you want to select a range of cells and delete the contents?

[santanuKD]

Yes pls . say a specific column or a range of cells

[mike7952]

This what you want ?

Please Login or Register  to view this content.

[arlu1201]

Thanks Mike. I didnt realise that could be done.

[mike7952]

Your welcome, probably better to Intersect the range.

Please Login or Register  to view this content.