Clear Contents on Double Click
Posted on 2014-12-11
I want to clear contents of cells by double clicking another cell. I had some code already in my spreadsheet that was doing something when I double click and trying to get it to work for this instance.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(.Cells, Me.Range("AQ10:AQ660")) Is Nothing Then
Cancel = True
Clear contents contents of cells AR and AU
For example, if I double click AQ10, then clear contents of AR10 and AU10 or if double click AQ11, then clear contents of AR11 and AU11...does this make sense? Thanks!