copy the selected range

[anilg0001]

when i press a1 then a1 value copy true
if i select d3:d8 then a1 cutcopy false and d3:d8 range should copy with out using Ctrl+C
how can i wrote macro?

[dilipandey]

Hi anilg0001,

Suggest you to elaborate more on your requirement and what is your ultimate goal - is it that when you select any range after a1, that range should be copied without pressing ctrl + C ?


Regards,
DILIPandey
<click on below * if this helps>

[anilg0001]

thanks for ur reply
a1 is only an example
i want to copy the cells where i am
if i am at a3
then a3 value copy just after i select cell d7 to d10
then that rage should copy and just after
if i select e10: f20 then that range should copy
thats all

that means on range select event which code i want to write?
selection.copy=true

[dilipandey]

I hope it would be just selection.copy

if i am at a3
then a3 value copy just after i select cell d7 to d10

You can be either at a3 or at D7:D10.. not on both places.
Ideally the line should be "If I am at a3 then a3 value gets copied just before I select range d7:d10" ... correct ?


Regards,
DILIPandey
<click on below * if this helps>