Hi Nick,
Thanks a lot for your inputs. They helped very much. Firstly, I tried
simply disabling screen updates. This allowed a "more graceful hang" - in
the sense that Excel could now close the VBA code window and the source &
destination workbooks. Excel could not exit however and required the Task
Manager to terminate.

The row copy and insert worked like a shot. Only, I do not want to copy
the complete row information. Will find a way to block out. Will column hide
help??

But the larger problem is still interesting. I have screen shots of
various stages. can I post them somewhere so that the "background boys" can
take a look at Excel itself to see how it can act with more grace?

Thanks once again for your very helpful inputs

Jai

"Nick Hebb" wrote:

It could be all the Activate's, Select's, and screen updating causing
the memory consumption. The code you wrote could be condensed into:

Application.ScreenUpdating = False
SUWb.Sheets(SUName).Rows(FIRSTROW & ":" & FIRSTROW + nos).Copy
MasterWb.Sheets(Catg).Rows(FIRSTROW & ":" & FIRSTROW).Insert
shift:=xlDown
Application.ScreenUpdating = True

----
Nick Hebb
BreezeTree Software
http://www.breezetree.com