excel hangup

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hello,
I have a file that has several sheets in excel, office
2000. There are 10000 records about 15 different
columns. I did a lot of copying and pasting. Even after
I close, then open....it takes forever to work with it
now. Takes quite a bit of time to open.

Is there some type of excel memory that needs to be
cleared?

Thanks,
 
Hi,
in your code after paste,
application.cutcopymode=false



'clears the clipbaord

Also, avoid the copy and paste method.
range("A1").value=range("B2").value
or whatever
- Mark
 
Back
Top