Cutting and Pasting values in a range of cells, with losing cell formatting?

[LucidCheetah]

I have a worksheet with many separate users. There are large ranges of cells being cut/copied/pasted frequently within the spreadsheet. The data is separated out into a nice clean grid using borders on the cell formatting. the issue is that when cutting and pasting the cell formatting of the original source cells is wiped clean after pasting. I have tried locking this out by playing with various different options within the Protect Sheet option. Nothing seems to work.

Personally, I know I can copy, paste, and the clear the original cells, but many people prefer the straight across cut/paste method. There are many many hands dipping into this one file and getting all the users on the same page with that method is just not going to happen. Is there some sort of macro or VBA option which I can lock in and restrict all cutting on the sheet to maintain the original formatting in the cut cells?

 

[crazydragon84]

exactly as you said, copy then delete in VBA is probably the only way

With Range(Copy_Range)
.copy Destination:=Range(Paste_Range)
.clearcontents
end with