Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks, Dave. It worked! Strangly, though, that's what I tried first and it
failed. Must have had another problem active at that time. I'll take a look at the like. Thanks! Ed Sowell "Dave Peterson" wrote in message ... Try: MyArray = [Sheet1!SavedArray] When I'm having trouble with names, I like to use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) utility "Name Manager.xla" from http://www.bmsltd.co.uk/mvp/ It really makes life a lot simpler. (you could see how that name was really defined. Yeah, you could have gone to Insert|Name|Paste, but Jan Karel's (et al) utility is a lot nicer.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing a named array | Excel Discussion (Misc queries) | |||
Using Named Range within an Array Formula | Excel Discussion (Misc queries) | |||
Named Array | Excel Worksheet Functions | |||
Named Ranges in Array Formulas | Excel Worksheet Functions | |||
Named range into an array | Excel Worksheet Functions |