On click within a range, copy and paste cell

[BRISBANEBOB]

I've been battling to get what should be a simple bit of VBA to run: when clicking in a range, that cell within the range is copied and pasted to another location within the same sheet.

Grateful for any help

[DonkeyOte]

Are you looking to use the SelectionChange event ?

Perhaps you could post what you have in mind... specifics etc...

Below is a very generic approach - would copy intersect of selected range and A1:C10 and paste resulting cells to the first blank row in Column Z (and below / right as appropriate pending size of Intersecting range)

Please Login or Register  to view this content.

To insert the above right click on Tab of interest and select View Code pasting above into resulting window.

Using the selectionchange event is not necessarily a good thing... you might want to make the action more deliberate (eg DoubleClick)

[BRISBANEBOB]

Thanks (again) Donkey Ote.

This is how I went about trying to copy, by double clicking on it, a single cell within the range P7:P78 to pasting it in cell C43 on the same sheet:

Please Login or Register  to view this content.

Needless to say, it didn't work. Nothing happens. Can anyone advise me where I am going wrong,

[DonkeyOte]

The BeforeDoubleClick event by default allows only for single cell selection so in truth the code can be condensed

Please Login or Register  to view this content.

Note that in the above you are always copying the value to C43 (overwriting what was there previously) - this requirement is implied by earlier code.

(the Cancel line cancels the double click so as to prevent you from going into edit mode in the Target cell)