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