I have a piece of code that takes a copied range and pastes it into another worksheet using the offset property. This piece of code is not working and I think that is has something to do with the "Destination".
Dim PasteRng As Range
Set PasteRng = Sheets("Summary").Range("A65536").End(xlUp).Offset(1, 0)
Destination = PasteRng
Any help would be appreciated. Also let me know if there is a better way to write this. Thanks
Dim PasteRng As Range
Set PasteRng = Sheets("Summary").Range("A65536").End(xlUp).Offset(1, 0)
Destination = PasteRng
Any help would be appreciated. Also let me know if there is a better way to write this. Thanks