View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Remove Copy Selection

Excellent...I put it in after the past in the last worksheet...works
perfectly...Thank you!

"Mike H" wrote:

Hi,

Put this line in immediatly after the .paste line

Application.CutCopyMode = False

Mike

"David" wrote:

I am copying contents of one worksheet to other worksheets and ending the
code back in cell A1 of the original worksheet, but the Copy Selection is
still around all the cells I copied. I've tried activating an empty cell
before going back to cell A1, but it is not working. I know this is just
cosmetic, but I'd like to clean this up and get rid of the copy selection
around the cells. Can anyone help? THanks!