| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clearing a selection
Hi team
after my macro has run and copied some cells to the next sheet Range("C5:E29").Select Selection.Copy I'm left with the dotted lines around the cells copies, how do I clear this selection. thanks john john Images of home (NZ) http:\\www.myplace.co.nz/home What we are up to in the UK http:\\www.myplace.co.nz |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clearing a selection
Hi, John,
application.cutcopymode = false empties the Windows clipboard and thus removes the dotted lines. Regards Pete "John in Surrey" wrote: Hi team after my macro has run and copied some cells to the next sheet Range("C5:E29").Select Selection.Copy I'm left with the dotted lines around the cells copies, how do I clear this selection. thanks john john Images of home (NZ) http:\\www.myplace.co.nz/home What we are up to in the UK http:\\www.myplace.co.nz |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clearing a selection
Add this line (just before your End Sub line):
Application.CutCopyMode = False HTH "John in Surrey" wrote in message ... Hi team after my macro has run and copied some cells to the next sheet Range("C5:E29").Select Selection.Copy I'm left with the dotted lines around the cells copies, how do I clear this selection. thanks john john Images of home (NZ) http:\\www.myplace.co.nz/home What we are up to in the UK http:\\www.myplace.co.nz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
| Clearing Drop Down Selection | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Object Type of a selection... counting rows in a selection | Excel Programming | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Linear Mode
