Is there a way to click on a cell then click a button with an assign macro that would clear the contents in the corresponding row for the cell that was clicked? I want the same button to clear the contents in the row every time a cell is clicked followed by the click of the button.

Thank you,
Areli