Proper code for Pasting Values

[jrnyman]

In another post, Dave Hawley wrote the "preferred way" of copying/cutting and pasting was:
Sheet1.Range("A1").Copy destination:=Sheet2.Range("A1")

Is there a similar short format for copying a cell and pasting only its values?

Additionally, can you combine commands such as Sheet1.Columns("A:A").Copy destination:=Sheet2.Range("A1")?

Thanks.

 

[Audiojoe]

I think it might be:

PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Obviously changing the conditions to suit you

 

[Legacy 98055]

If values are all you need then try,

Sheet2.Range("A1").value = Sheet1.Range("A1").value

Tom
This message was edited by TsTom on 2002-04-10 03:14

 

[Dave Hawley]

Arh! Tom, it's good to see some good habits being formed.