Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pastespecial
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)? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pastespecial
Hello Claude
Application.CutCopyMode = False HTH Regards Pascal "Claude" a écrit dans le message de ... 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)? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pastespecial
Add these 2 lines in your macro:
Application.CutCopyMode=False Cells(1,1).Select -----Original Message----- 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)? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pastespecial in vba | Excel Programming | |||
vba pastespecial | Excel Programming | |||
PasteSpecial:VBA vs right click | Excel Programming | |||
PasteSpecial failed | Excel Programming | |||
pastespecial | Excel Programming |