Clear Content Macro?

[sgris]

I am trying to come up with a way when I change a name in a cell to erase the values associated with the old cell name. I think I need a macro, but have no idea if I do need one or what it would be.

Shawn

[vipul.halbe]

attach a example file. With an explaination. We will try to solve it.

[sgris]

This is going to take place on the add/cut worksheet. I'm looking for a way to have V14 clear when u14 changes names. This is going to happen when e28 changes. I want to link e28 to u14 so I only have to change e28. There are several other spots in the document this type of action needs to take place.

[:) Sixthsense :)]

Do Right click on the sheet tab and select view code and add the below code in the vba code window.

Please Login or Register  to view this content.

[sgris]

I just tried the previous code and it worked great. How would I add more cells that follow this type of code?

[:) Sixthsense :)]

Revised version of code for doing changes on your own. Just copy from IF until end if and paste it before end sub and change it to your next condition cells accordingly.

Please Login or Register  to view this content.