I have a simple line of code:
Pretty straight up, takes the data in Sheet 1 and puts it in Sheet 2.
This has worked for ages and ages. However just today Excel when processing will sit on this line for ages, the window will go "no responding" etc and just sit there.
Users usually close Excel at this point.
I have tried all the variations of the above that I can think of. But all act the same.
I did leave it unresponding once, and after about 30 minutes it completed the action.
The data set is usually A to L and never more than 40 rows or so.
Any ideas on whats going on?