using predefined names in VBA

Question

The code is really simple and I'm just trying to copy values in from_range and paste them in to_range. But it's just not working out...

Sub test14()
    Range("to_range") = Range("from_range")
End Sub

Before,

After, not sure why everything in to_range is gone

Desired, just want to overwrite to_range with from_range

Could someone explain what's going on here? Thanks.

Answer 1

also you can do this job with Select:

Range("from_range").Select
Selection.Copy
Range("to_range").Select
ActiveSheet.Paste