Don't know if this would help... Sometimes if it gets too complicated, a
Dictionary or Collection object can be very helpful.
Here's a quick Collection example. There are many ways to handle this.
This is a rather simple example to demo if this might be something worth
looking into.

Sub Demo()
Dim Col As New Collection
Dim v As Variant

Col.Add Array(1, 2, 3, 4), "Recond_1"
Col.Add Array(3, 4, 5, WorksheetFunction.Pi), "Recond_2"
'// You can keep adding Records here ...

'Update Record 1, 4th item:
v = Col(1)
v(4 - 1) = "4th item now 99"

Col.Remove (1)
Col.Add v, "Recond_1", 1

End Sub

Again, lots of different options here. Good luck. :)
--
Dana DeLouis
Win XP & Office 2003


"TheVisionThing" wrote in message
...
Tom,

Certainly didn't want to give the impression that I don't want a solution,
and apologize if I came across that way and for any obtuseness I
displayed. I have enormous respect for your abilities and for all the help
you've provided in this forum over the years.

I'll rewrite my code in this fashion this weekend, see if it avoids the
'out of memory' error and report back.

Many thanks,
Wayne C.