Hi All
I have extracted below code from this site.
The issue is that I want to copy values from different cells when I double click Target, Range("A1:A10")) the codes copy
on the same row value like if double click on A1 then code copy A1 cell to AA1 , B1 to AA5 and C1 to BB2.
if double click on A2 then code copy A2 cell to AA1 , B2 to AA5 and C2 to BB2. and like this on other target cells.
Can it be possible ???
I have extracted below code from this site.
Code:
Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("A1:A10")) Is Nothing Then Exit Sub
Cancel = True
Range("B1") = Range("B1") & vbCrLf & Target.Value
End Sub
The issue is that I want to copy values from different cells when I double click Target, Range("A1:A10")) the codes copy
on the same row value like if double click on A1 then code copy A1 cell to AA1 , B1 to AA5 and C1 to BB2.
if double click on A2 then code copy A2 cell to AA1 , B2 to AA5 and C2 to BB2. and like this on other target cells.
Can it be possible ???