I have written a macro that in part of it, I set the selection (for example, range” AD4 to BC 11”) to” T1” and then make a copy of this selection and paste it in another range (for example, range” BD4 to CC 11”) and then set the new range to another variable. (for example,T4).
Now my problem is when I set T4, the T1 unexpectedly is no longer the old selection (range” AD1 to BC 11”) but has converted to the range I have assigned it to T4 (” BD4 to CC 11”.see the excel attachment. . The code is assigned to blue circle).
Can you guide me on this issue?

Attached Files

question.xlsm (89.3 KB, 4 views)