excel hangup

[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,

 

[Mark]

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