range = range
 

Working on the same principle sheet1.cell A1 = sheet2.cell A1

is there a way of doing: sheet1.namedRange1 = sheet2.namedrange2
and populating all cells with all values in the range?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=380025

range = range
 

in principle yes.

If the Name objects resolve to Ranges
(ofcourse names can also hold formulas and constants)
and it helps if the named ranges have same size.

Also note you need different syntax
a named range cannot use "tunneling" syntax.
Range("sheet1!mydst").value = Range("sheet3!mysrc").value

Be aware that names can be defined at workbook level
and at worksheet level.

When you work with names (or plan to)
download NameManager addin.
http://www.oaltd.co.uk/MVP/Default.htm


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


MattShoreson wrote :


Working on the same principle sheet1.cell A1 = sheet2.cell A1

is there a way of doing: sheet1.namedRange1 = sheet2.namedrange2
and populating all cells with all values in the range?

range = range
 

much appreciated

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=38002