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

LucidCheetah

New Member
Joined
Dec 11, 2017
Messages
15
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?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

crazydragon84

Board Regular
Joined
Feb 19, 2015
Messages
195
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
 

Forum statistics

Threads
1,148,140
Messages
5,745,035
Members
423,917
Latest member
Frank1931

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top