Quote Originally Posted by danny2000 View Post
If I set Range1 = Range2 this works. But if later I try to set Range1 = Range3 this doesn't work. Range1 stays equal to Range2.
If your Range was a single Cell reference it should have worked. If the range includes a multiple cell area you must qualify the range with ".Value" or it will not work. At least with my test in Excel 2003. I was having trouble with the Range = Range until I added .Value to the source range. This will also work to duplicate a range from another worksheet if the source range is qualified with the Workbook and Sheet name.

Range("B24") = Range("B20") ' This Works
Range("B24:C24") = Range("B20:C24").Value ' This Works
Range("B24:C24") = Range("B20:C24") ' This does NOT Work