how to assign ranges on different sheets to an array
 

Tom
You never cease to amaze me. Sunday night at 10pm and I had a good answer by
10:30. The intermediate array speeds things up tremendously.
Ryan,
Thanks, but Tom is correct in that the problem is a little trickier than your
solution will handle.
Alan,
I downloaded all your matrix utilities a year or so ago. I will I review those
this evening as I am sure some of that great stuff will come in handy in my
current project as they have in the past.

Thanks to all. This group is one incredible resource for excel programming.

Ken
Norfolk, Va