copy and pasting and getting that annoying copy selection showing 1

[Chrissirhc]

Hi,

I copy paste from one range to another using the below.

Range("ExpiryMonths").Copy
Range("expiryMonthsCopy").PasteSpecial xlPasteValues, xlPasteSpecialOperationNone

What is annoying is that when the code has finished running, the selection is stil showing and the status bar is asking to select place to paste this selection.

What is the cleanest and most conventional way of getting rid of these side effects?

(using Excel 2000)

Thanks,

Chris

 

[GlennUK]

It's

Application.CutCopyMode=False



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.