| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I unselect a cell in a macro
The cells that you copy when you want to paste data into another location.
After you copy cells, a moving border appears around them to indicate that they've been copied. In my macro I copy the value at a cell and paste to a child sheet.....the copied cell continues to have the moving boarder..Is there a command in VAB to deselect to shut off the moving border ???? Thanks for any help Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I unselect a cell in a macro
Application.CutCopyMode = False
"cgnotrom" wrote: The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they've been copied. In my macro I copy the value at a cell and paste to a child sheet.....the copied cell continues to have the moving boarder..Is there a command in VAB to deselect to shut off the moving border ???? Thanks for any help Chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I unselect a cell in a macro
Thankyou so much. I have been searching for this for a week now. Just didnt
know how to ask the f1 file for the proper responce. Thanks again. Chris "Sean Timmons" wrote: Application.CutCopyMode = False "cgnotrom" wrote: The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they've been copied. In my macro I copy the value at a cell and paste to a child sheet.....the copied cell continues to have the moving boarder..Is there a command in VAB to deselect to shut off the moving border ???? Thanks for any help Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deselect (Unselect) Cells | Excel Discussion (Misc queries) | |||
| Unselect all selected areas in all sheets | Excel Discussion (Misc queries) | |||
| How can I select one checkbox and have it unselect other ones? | Excel Worksheet Functions | |||
| Unselect Option Box | Excel Discussion (Misc queries) | |||
| Can't unselect a cell - What's wrong??????????? | Excel Discussion (Misc queries) | |||
Linear Mode
