Clear Contents in One Cell based on another value

Should be a simple macro but I'm having a problem getting it to work. The macro should be looking In column N for a Yes or a blank cell. If the cell in N = Yes then the contents on the same Row in Column J should be cleared and then move onto the next available cell Based on if Column I is empty or not. Column I is another value but should always be filled out so I'm using that as an indication on when the loop should stop.

Please Login or Register  to view this content.

Hi,

You probably need to specify ActiveSheet.Columns("N"), and ActiveSheet.Cells(cell.Row, "J")

Please Login or Register  to view this content.

Thanks. It worked.

Thanks A Lot