Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |