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

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
>

Add this line (just before your End Sub line):
Application.CutCopyMode = False
HTH

"John in Surrey" <j@myplace.co.nz> wrote in message
news:dtd3n1luq3ita37g6qtgcl3enpru7o9h2b@4ax.com...
> 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