Set one Range equal to another Range?

**danny2000** · 10-01-2009, 06:17 AM

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.

Does anybody know how to solve this?

Thanks:

**D_Rennie** · 10-01-2009, 06:21 AM

In theroy there should not be any issue.

if you post some code up people can see whats going on, other than that im not sure.

**savbill** · 01-10-2012, 08:55 AM

Originally Posted by danny2000

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

**Kelshaer** · 01-10-2012, 09:16 AM

the range dimension should be the same:

Please Login or Register  to view this content.

**royUK** · 01-10-2012, 09:19 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here