Hi
I think that the problem that you are suggesting is not possible.
The text in cell S2 is pasted to T2 before any deleting is done.
Excel will never do those deleting commands until it has finished the copy and paste.
It is impossible for Excel to do those deleting commands until it has finished the copy and paste.
I expect you have a different problem.
I expect the macro is not doing what you think it is doing.
I expect the macro is working perfectly, but it is doing something different to what you want.
I think you need to explain very carefully and very fully , exactly what it is that you are trying to do
Important is : You must always say exactly what worksheet is having any actions to be taken.
Reply With Quote
Bookmarks