If you are doing a series of cut, copy, paste or insert then you can put the
Application.CutCopyMode = False after the last one. As Susan pointed out, it
makes the marching ants go away from the last copy range if you used the
Select method to copy the range. If you use the direrect copy method like:
Then the marching ants don't show up.
If you are using PasteSpecial, you will need to turn the CutCopyMode off
after you have finished all of your copy actions. The number of times that
it is used is up to the programmer, but generally speaking, it is only
required after all copy processes are finished.