| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deselecting active cells after pasting
Hi,
I've written VB code to copy and paste. The problem is when I go back to the Excel environment, the cell that was copied is still active (i.e. it still has that running border around it). To deselect the cell I press the esc key. How can I do this in VB? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deselecting active cells after pasting
Recording a macro including pressing Esc immediately will show you the
appropriate VBA statement (Application.CutCopymode=False). Regards, Stefi €žDazza€ť ezt Ă*rta: Hi, I've written VB code to copy and paste. The problem is when I go back to the Excel environment, the cell that was copied is still active (i.e. it still has that running border around it). To deselect the cell I press the esc key. How can I do this in VB? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deselecting active cells after pasting
Application.CutCopyMode
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dazza" wrote in message ... Hi, I've written VB code to copy and paste. The problem is when I go back to the Excel environment, the cell that was copied is still active (i.e. it still has that running border around it). To deselect the cell I press the esc key. How can I do this in VB? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting active links in excel | Excel Discussion (Misc queries) | |||
| pasting textbox value to active cell | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| Deselecting unwanted cells | New Users to Excel | |||
| Opening and pasting in active workbook | Excel Programming | |||
Linear Mode
