Excel has a short attention span when you copy a range of cells (including a single cell). As soon as you do something other than paste it forgets what it had highlighted.

If you copy the 'text' inside the cell rather than the cell itself, that clipboard content will remain available to paste until it is over-written by another copy command.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia