Brian,

Try

Range("Range1").Copy Destination:=Range("Range2")




"Brian Matlack"

wrote in message
news:Brian.Matlack.1xxlnz_1131039002.3476@excelfor um-nospam.com...

Hi!
I'm looking for a quick copy code
1. What code do I use to copy a named range (formulas) to
another named
range (values only)?
2. What do I need to do if some cells are merged in the
original range
and not in the recieving range or vise versa?
Thanks


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread:
http://www.excelforum.com/showthread...hreadid=481945