Double click on a Cell range and copy data to another cell

[naveen4pundir]

Hi Guys,

I want double click on the C2 to C25 cells and copy the selected content and past that data in to the K2 cell in the same sheet(Sheet1).

Below mention macro is working fine but it selected only fixed cell C2 but i want if i click on C3 it's data go to K2 or if i click on C4 same action repeat here

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

Automate Worksheets

[naveen4pundir]

Thanx a lot ..it's working..