need custom cut and paste functions
 

Hello,

I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.

Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from? That way my cut and paste would really be a copy, paste, delete which
would get around the problem. I could tie the macros to the shift-del and
shift-ins shortcut keys.

I tried recording a macro to get a feel for what would need to be done by
copying, pasting and deleting a selection of cells but the problem is that I
don't know how to get one function to remember the selection stored by the
other function etc.

I think such functions would be very useful to other people as well.

with thanks...