PDA

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