If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|