Copy question
 

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.

Copy question
 

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.

Copy question
 

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.