Selection.Copy
 

Please help...
I have no formulas in an excel sheet, its simply values. For some
reason when I do this...

Cells.Select
Selection.Copy

The code gets hung up for 5 minutes. I have checked the machine and it
is not running any other processes...I have 80 gig ram, everything seems
fine. Does anyone know why this might be happening???

TIA - mike

*** Sent via Developersdex http://www.developersdex.com ***

Selection.Copy
 

You have an 80 gig hard drive. I doubt you have 80 gigs of ram. Do you
realize that Cells.Select selects every cell in the sheet? That's over 16
million cells. Yes, that takes a while if many of those cells are occupied.
HTH Otto
"Michael Smith" wrote in message
...
Please help...
I have no formulas in an excel sheet, its simply values. For some
reason when I do this...

Cells.Select
Selection.Copy

The code gets hung up for 5 minutes. I have checked the machine and it
is not running any other processes...I have 80 gig ram, everything seems
fine. Does anyone know why this might be happening???

TIA - mike

*** Sent via Developersdex http://www.developersdex.com ***

Selection.Copy
 

Hi Michael,

One suggestion: try emptying the temp directory:

Close Excel and reboot system | Start | Run | %temp% | delete all files and
folders

Having done this, re-open Excel and try the copy operation again.


---
Regards,
Norman


"Michael Smith" wrote in message
...
Please help...
I have no formulas in an excel sheet, its simply values. For some
reason when I do this...

Cells.Select
Selection.Copy

The code gets hung up for 5 minutes. I have checked the machine and it
is not running any other processes...I have 80 gig ram, everything seems
fine. Does anyone know why this might be happening???

TIA - mike

*** Sent via Developersdex http://www.developersdex.com ***