Cut

Home Search Site Map

Up
Clear
Copy
Cut
Delete...
Delete Sheet
Fill
Find...
Go To...
Links...
Move or Copy Sheet...
Object
Office Clipboard...
Paste
Paste as Hyperlink
Paste Special...
Redo
Replace...
Undo

New! Excel User Group Now Open @ www.excelusergroup.org,

Menu command Type What happens next?
Cut  

Takes the cell(s) currently selected and places them on the clipboard ready to be pasted into another part of the workbook or into another application, e.g. Word. When 'pasted into their final destination, the cells will be 'cut' from their original location. Like copy, caution should be taken within Excel as it maintains it's own clipboard which is very 'fragile' and can be cleared by simply pressing the 'esc' key for example.  Latter versions of Office have had a multi-level clipboard which can hold multiple pieces of information from across Office application. Care should still be taken with Excel's version as it is extremely frustrating to copy something and when you go to use it, find it gone! You can tell when Excel still has it's clipboard retained as the selection of cell(s) will have a moving dotted line around it, showing you that Excel is in 'Cut/Copy mode'.

Sub CutData()
'Cuts the data from A1 and pastes it to B1 in one operationon
Range("A1").Cut Destination:=Range("B1")
End Sub

Top

Copyright Nick Hodge 2009. All Rights Reserved.