I need to clear the value of the first cell of the row that is double-clicked

What would be the line of code to clear the value of the first cell of the row that is double-clicked? The row 2, for example: I have random values in cells A2:A10, but I want only A2 to be cleared if I double-click anywhere in the range of B2:G2, where I have set Cancel = True

Untested, but try:

Please Login or Register  to view this content.

I am pretty sure Trevor's code will work ("=" not needed) but I would inclined to use

Please Login or Register  to view this content.

Target is more reliably the cell that was double-clicked, although I can't think of a way that it would not also be ActiveCell. Also, I happen to like letter column references vs. numeric, just personal preference.

You're welcome. Thanks for the rep.

@6SJ: missed your comment. Not exactly sure how that equals sign got there, but it wasn't meant to be. The perils of drafting untested code on an iPad strike again. In a quandary now whether to correct it as that would lose the context for your comment .

It should work ok as double clicking the cell would make it the Active cell. But I think Target is preferable.