| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unselect selection
Hi,
I am coping and pasting cells via a macro. When it is done the last cells copied are still selected, the dashed lines around the cell indicating a copy function. How do I get it to stop selecting the last copied cells. Kind of like hitting escape on the keyboard? Thanks, Ivano |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unselect selection
Application.CutCopyMode = False
Place this at the end of your macro -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Ivano" wrote: Hi, I am coping and pasting cells via a macro. When it is done the last cells copied are still selected, the dashed lines around the cell indicating a copy function. How do I get it to stop selecting the last copied cells. Kind of like hitting escape on the keyboard? Thanks, Ivano |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unselect selection
worked like a charm... thanks
"Michael" wrote: Application.CutCopyMode = False Place this at the end of your macro -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Ivano" wrote: Hi, I am coping and pasting cells via a macro. When it is done the last cells copied are still selected, the dashed lines around the cell indicating a copy function. How do I get it to stop selecting the last copied cells. Kind of like hitting escape on the keyboard? Thanks, Ivano |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unselect? Deselect? | Excel Programming | |||
| now trying to unselect a sheet | Excel Programming | |||
| How to unselect? | Excel Programming | |||
| Unselect Option Box | Excel Discussion (Misc queries) | |||
| Unselect Filtre .... | Excel Programming | |||
Hybrid Mode
