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 |