• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

deleting contents of multiple cells once i delete the content of specific cell

N

nader assaleh

Member
hi all
my question is
if say cell A5 and b12:c16 all have values (numbers)
what i want if i erase the content of A5
all other cells values (b12:c16) should be erased automatically.

thanks
 
Hi Nader,

Formulas cannot delete data but can place a null string in cell. Deleting complete data can be done through VBA.

Regards,
 
Few Questions:

1. Are the numbers in the range B2:C16 are manually entered or coming from some formula?
2. What should happen if you re-enter a value in A5?

Regards,
 
Hi Somendra
if A5 is aleady has no value and cells b12:c16 have values. is there a way to check if A5 is empty then to clear
cells b12:c16. note that cells b12:c16 already have data validation.
 

Attachments

@nader assaleh

Your first requirement was to delete range B2:C16 when you delete cell A5, and if you re enter any thing in A5 nothing should happen. Now after this if you again delete A5 the data in range B2:C16 (if any) will be deleted. The program is doing it.

Second, B2:C16 has no data validation.

Regards,
 
hi
what i mean, if cell A5 has no value i want to block user to enter any value in the cells b2:c15.
regarding data validation i meant if suppose data validation is already applied on that range is there a way
to do it in a way other than data validation.
sorry for inconvenience
 
You must log in or register to reply here.
Back
Top