Hi,

I had written a macro which copies data from one location & paste that in other location. Now when I execute this macro, I am unable to perform any copy-paste in other execl files & other applications. Looks to me as if the macro is using entire memory for this.

Is there anyway where I can free the memory for other use. I can't pass data into a variable as they are not in a proper struture.

Abhinav...

well, step 1 should be to check and see if the system is using all resources, task maanger will tell you that

step 2 would be to reproduce the macro here and we can see if it can be made less intensive?