Copy

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, Check It Out!


Menu command Type What happens next?
Copy  

Copies 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 'copied' in their new location and still remain in the original one. As with 'cut', 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.  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 CopyData()
'Copies the data in A1 and copies it in B1 in one operationon
Range("A1").Copy Destination:=Range("B1")
End Sub

Copyright Nick Hodge 2008. All Rights Reserved.