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

Hi Doug929

On this page I use the Excel Filters to do it
Try this also

http://www.rondebruin.nl/copy5.htm

Try this one
http://www.rondebruin.nl/copy5.htm#all


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Doug929" wrote in message ...
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 I'm 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