Range specified on Before Double Click event does not work

Hi all my code is as follows

Please Login or Register  to view this content.

The purpose of the code is to double click on any cell from A43 to (A and lastrow) and copy the items of the same row to the sheet named "Form". With the code above, i wanted the double click event to be functioning only for the A43 up to A and lastrow range and on the rest of the cells do nothing if double clicked any of them. However, the range A43 to A and lastrow works with the result that i want, but for the rest of the range defined, if i double click on any cell, the sheet Form is activated without copying any cells. If i define a fixed range like A1:R42 this works and the double click does nothing. If i define a dynamic range using lastrow parameter this does not work. Im i doing something wrong?
Any help appreciated.