Thanks Ron but as I go through the list and tabs what I am cutting and
pasting is getting smaller and smaller, some how I think Excel is keeping
track of something that I do not know understand.


I have this long list of records and I separate it into new tabs by stepping
down through the rows checking for a different value. When I get a different
value, I cut and paste the data from that point down to a new tab and then
start again on that new tab till Im done. I re-use the same named range for
the cut and paste each iteration.

It worked fine for awhile but now I have a huge file and it is running out
of resources. Is there a way to 'clear' the resources each iteration or
something to that effect? I seem to remember stack issues but do not know how
to go about it in VBA.

Thanks