Hi,
1) I am not exactly sure why you intend to copy the data since in any case
you do not plan to paste it immediately. Why not "Go do something else" ,
copy data & then paste it immediately.
2) If you still want it the your way, you can try copying data to the
windows clipboard (instead of office clipboard) & check if it works. Check
the link below
http://www.cpearson.com/excel/clipboard.htm

HTH
--
Tausif Mohammed


"k1sr" wrote:

I'm guessing I'm not the only one with this problem, but why on earth is
Excel the only Office program which doesn't allow you to copy a selection, go
and do something else, then paste the data...?

Is there any way (with script) that I can copy a range of cells from Excel
such that they are stored in the clipboard (like a table) allowing me to go
and do something else and paste the data at any time (without having to keep
the little dotted border around the range I copied)