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

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=48194

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

Hey Chip!
Works Great! Thanks alot!


--
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