macro copy paste

[max_max]

Hello to all.
The attached macro cuts and then pastes into double-clicked ranges.
was created with the macro recorder.
can you modify it that works in the 3 fixed ranges?
max_max

[JLGWhiz]

this will only allow the called macro to run if the clicked cell is in one of the three ranges.

Please Login or Register  to view this content.

[xladept]

Try this:

Please Login or Register  to view this content.

[max_max]

Thanks you JLGWhiz and Xladept
can the ranges be separated?
max_max

[xladept]

Try this:

Please Login or Register  to view this content.

[max_max]

Hi xladept work fine!
Is it possible to copy paste only values and not the color of the cells?
max_max

[xladept]

Like this?:

Please Login or Register  to view this content.

[max_max]

Hi xladept it's ok.!
it is possible if the cell D14 is selected by double-clicking the cursor blinking
this does not stay

Please Login or Register  to view this content.

[xladept]

Like this?:

Please Login or Register  to view this content.

[max_max]

the cursor in the cell
Cells (r, 4) .Select
it should not blink

[Ozex]

Or this??

Please Login or Register  to view this content.

[max_max]

Hello,
is this correct?

Application.SendKeys "{ESC}"

Why are not the formulas paste for double-click?

[xladept]

It only blinks if that's the cell you clicked on - try clicking on a different cell.

[max_max]

Hi, now it does not blink anymore and the formulas are pasted, is it correct?

Please Login or Register  to view this content.

[xladept]

For formulas:

Please Login or Register  to view this content.

* Yes it looks good!

[max_max]

Ok xladept works fine, but the other flashes