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