Delete cell contents based on certain column, update continuously

I want to delete the contents of a cell in row x based on if the corresponding cell in the same row is "active" or "closed"
I want this to update continuously so whenever I make a change, the contents will be deleted.
Any ideas?

Your explination left out some details so you'll have to modify this code to suit your needs. I left comments in the code to help.

Also, I'm guessing you only want it deleted if the status is "closed", but it's not clear to me.

Please Login or Register  to view this content.

Sorry, I should have made it more clear.
Col 6 contains 'closed' or 'active', and if it says 'closed' in a particular row, I want to clear or hide the contents of col 5, row x.

Please Login or Register  to view this content.

I actually get an error, it says'object required' at the first if statement

That's what I get for typing free-hand. Replace that If line with:

Please Login or Register  to view this content.

I have that too. Im not sure why its giving me an error

Actually I just needed to add the ByVal Target As Range. However, nothing is happening on my sheet.

Would need to see the sheet and the code you are using, or an example.

The way the code works now, as soon as you type something into column 6, if that something is "closed", column 5 of that row gets cleared.

Where did you place the code?

I figured it out, I just had it in the wrong worksheet. Thank you

Does anyone know if there is a quick way to refresh the sheet instead of going through and re-typing in things to make the changes?

Please Login or Register  to view this content.