Hi,

My code copies and paste a row of data. When the data is pasted the row that
was copied is still highlighted as if it is ready to be pasted again. how
can I unhighlight this row. I tried to select another cell but the row still
remains highlighted.


Thanks for any help.

Hi,

Put this after your paste command

Application.CutCopyMode = False
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ram" wrote:

> Hi,
>
> My code copies and paste a row of data. When the data is pasted the row that
> was copied is still highlighted as if it is ready to be pasted again. how
> can I unhighlight this row. I tried to select another cell but the row still
> remains highlighted.
>
>
> Thanks for any help.
>
>

Thank you

"Mike H" wrote:

> Hi,
>
> Put this after your paste command
>
> Application.CutCopyMode = False
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "ram" wrote:
>
> > Hi,
> >
> > My code copies and paste a row of data. When the data is pasted the row that
> > was copied is still highlighted as if it is ready to be pasted again. how
> > can I unhighlight this row. I tried to select another cell but the row still
> > remains highlighted.
> >
> >
> > Thanks for any help.
> >
> >