| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Copy Selection | Excel Discussion (Misc queries) | |||
| copy sum selection | Excel Programming | |||
| row selection and cut + copy | Excel Programming | |||
| Copy Selection to new sheet | Excel Programming | |||
Linear Mode
