Paste

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?
Paste  

Places whatever has been 'cut' or 'copied' to the clipboard into it's new destination. In Excel if you have copied a range, say A1:A100 and you want to paste it to B1:B100 you are best to simply select the top left cell and select 'paste'.  In this case B1.  This is because Excel will error if the 'shape' for the 'destination' range is not exactly the same as the 'source' range. Selecting a single cell lets Excel work it out for itself. Beware however that you do not inadvertently paste over other valuable data, although generally again, Excel will warn you before doing this.

Sub CopyAndPasteData()
'Copies the data and places it on the clipboard
Range("A1").Copy
'Pastes it to the range B1 on Sheet1
Worksheets("Sheet1").Paste Destination:=Range("B1")
'Kills the Excel clipboard
Application.CutCopyMode = False
End Subub

Top

Copyright Nick Hodge 2008. All Rights Reserved.