pastespecial

  • Thread starter Thread starter Claude
  • Start date Start date
C

Claude

Hi all
I use a macro to copy cells with pastespecial from one
sheet to another. Is there a way to get rid of
the "highlighting" around the copied cells on the first
sheet (other than selecting a cell on the first sheet and
using sendkeys {ESC} to get excel out of copy mode)?
 
Add these 2 lines in your macro:

Application.CutCopyMode=False
Cells(1,1).Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
A simple if <> nn then Msgbox "No Match" 5
Select Case Code does not run... 10
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Convert A1 value to a sheet name and copy to it 2
Copy row info but not in normal column sequence 6
Range(sheet2) = Range(sheet1) 11
Copying cells and formula from closed workbook to all sheets in open workbook 0

Back
Top