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.
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.