Direction of Paste

[LucyN]

When I copy cells, how can I change the direction of the paste....
for example I have 1 2 3 4 5
and I want to paste as 5 4 3 2 1

Thanks!

 

[John Spencer]

I don't know of a way to do this in Access. There may be a way to do
this in EXCEL, but I don't know that either.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Paul Shapiro]

You can find the Windows API's to work with the clipboard. Read the data off
the clipboard in your code, and then write code to reverse the order.
Finally, insert your data wherever it was you wanted it pasted. Not trivial
code, but definitely do-able.