Thread: Named Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jag Man Jag Man is offline
external usenet poster
 
Posts: 38
Default Named Array

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