Remove data by double click

I'm trying effect some change to my worksheet by double clicking the cells in the range D6:D50.

When I click on a cell in this range , the cells in that row from the target cell to column I would have their content removed.

For example , if I double click on D6 then the cells D6:I6 would be blanked out.


Can someone advice some code to accommodate this?

Grateful for any help.

Right click on your sheet and paste this code as a starter

Please Login or Register  to view this content.

Many thanks - that's working fine. Grateful for your time and expertise.

Glad it worked out for you, thanks for the rep, and you're very welcome.