View Full Version : Solved: bypassing clipboard
philfer
12-29-2007, 04:03 AM
I want to copy and paste values but bypass the clipboard. I do :
Sheets("Sheet1").Range("a1:b10").Copy _
Sheets("Sheet2").Range("a1").xlValues
it doesnt like it
What should I do instead
Bob Phillips
12-29-2007, 04:28 AM
Why do you need to bypass the clipboard?
Simon Lloyd
12-29-2007, 04:29 AM
Sheets("Sheet1").Range("a1:b10").Copy Destination:=Sheets("Sheet2").Range("a1")
but you need to use paste special
philfer
12-29-2007, 04:35 AM
I bypass the clipboard because in some instances I copy from another spreadsheet and it eliminates hassle.
It is the pastespecial I am having trouble with so in the reply below :-
Sheets("Sheet1").Range("a1:b10").Copy Destination:=Sheets("Sheet2").Range("a1")
How would I adapt that for pastespecial values
Simon Lloyd
12-29-2007, 04:52 AM
record it in the macro recorder.....however you wil always use the clipboard if you copy something, if you reference it via formula you do not use the clipboard but if the values in the source book change then so will your destination book when both are open!
Simon Lloyd
12-29-2007, 04:56 AM
Sub Macro1()
Range("A1:A10").copy
With Sheets("Sheet2").Range("A1")
.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
End Sub
HaHoBe
12-29-2007, 05:55 AM
Hi, philfer,
just copy values directly without using copy&paste:
Sheets("Sheet2").Range("A1").Resize(10, 1).Value = _
Sheets("Sheet1").Range("A1").Resize(10, 1).Value
Ciao,
Holger
johnske
12-30-2007, 05:29 PM
I bypass the clipboard because in some instances I copy from another spreadsheet and it eliminates hassle.
It is the pastespecial I am having trouble with so in the reply below :-
Sheets("Sheet1").Range("a1:b10").Copy Destination:=Sheets("Sheet2").Range("a1")
How would I adapt that for pastespecial valuesSimple answer is - you can't - bypassing the clipboard like that only works for a straight paste, not a pastespecial. If you only want the values, copy them directly without a paste as HaHoBe has shown.
mikerickson
12-30-2007, 08:47 PM
Sheets("Sheet2").Range("a1:b10").Value= Sheets("Sheet1").Range("a1:b10").Value
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.