aerodoc
03-20-2014, 10:08 PM
I want to directly copy a range from one sheet to another. This is a current solution, but it has some issues:
Range(Sheet1.Cells(1, 1), Sheet1.Cells(5, 5)).Copy
Sheet2.Range("A1").PasteSpecial xlPasteValues
I want to do something more like this, but it does not work as is:
Range(Sheet1.Cells(1, 1), Sheet1.Cells(5, 5)) = Range(Sheet2.Cells(1, 1), Sheet2.Cells(5, 5))
Range(Sheet1.Cells(1, 1), Sheet1.Cells(5, 5)).Copy
Sheet2.Range("A1").PasteSpecial xlPasteValues
I want to do something more like this, but it does not work as is:
Range(Sheet1.Cells(1, 1), Sheet1.Cells(5, 5)) = Range(Sheet2.Cells(1, 1), Sheet2.Cells(5, 5))