Excel VBA user double clicks cell from anywhere
<p>I'm using Excel 2010 and have a range of codes in column A.  When a user double clicks one, it copy the value of whatever it is to cell A2 using the below code on the BeforeDoubleClick event of the worksheet - this works fine:</p>

<pre><code>If Not Intersect(Target, Range("A4:A100000")) Is Nothing Then Cancel = True
Target.Copy Destination:=Sheets("GL Codes").Range("A2")
</code></pre>

<p>The problem is, if they click the description in column B it doesn't copy the respective value from column A - how do I do this?</p>

<p>In summary, no matter where in the row the user double clicks, the cell value from column A needs to be copied to A2 - is this possible?</p>