Double Click event - copy

[cajand]

Hello,

I got a list of items in P10:P20.

I want to be able to doubleclick a cell in P10:P20 and its contents should be copied and pasted
in cell G9.

The next time I double click on a cell in P10:P20 I want it to skip to the next empty cell in the G column.

I found a couple of different soloutions but none that skips to the next empty row.

Can anyone help me get started?

Thanks in advance!

[pjwhitfield]

use the following to identify the next empty cell in column G

Please Login or Register  to view this content.

so your code could be

Please Login or Register  to view this content.

[Debraj Roy]

Check the attached file..

Please Login or Register  to view this content.

Code need to be placed in ThsiWorkbook - Module

EF1050983.xlsm

[cajand]

Thank you Debraj Roy! It worked perfect!

Is it possible to make the macro work if the user copies the entire worksheet within the same workbook?
Basicly there are som sheets where I dont want the macro to work, but I want it to work on this specific sheet and for the user to be able to copy the specific sheet.

[MarvinP]

Hi cajand,

Put my code behind an individual sheet instead of the Workbook. See the attached. It is very similar to Deberaj's but I like to use Cell(row,col) format better.