Hi all
I am using the code below with a BeforeDoubleClick event. I need help for the =CJ3 to be relative.
If Not Intersect(Target, Range("c:c")) Is Nothing Then 'change this column to suit
Target.Formula = "=CJ3"
Target.Offset(1, 0).Select
End If
Thank you!