ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 hangs (https://www.excelbanter.com/excel-programming/395674-excel-2003-hangs.html)

pwillain

Excel 2003 hangs
 
Since security update of Aug 15, Excel 2003 hangs on the following macro
instruction:

Range("Y5:AC65000").Select
Selection.ClearContents

Did anybody else experienced it?

Will remove the security update

BJ Hughes

Excel 2003 hangs
 
I've just started seeing this too - clearcontents hangs Excel, but only with large ranges. Did removing the security update work? Restoring the system to a previous date did nothing.


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

BJ Hughes

Excel 2003 hangs
 
I've just started seeing this too - clearcontents hangs Excel, but only with large ranges. Did removing the security update work? Restoring the system to a previous date did nothing.


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

pwillain

Excel 2003 hangs
 
Restoring the system did not work, but cleaning the registory did work. This
was not a memory problem since I work with 4GB.
Thanks

"BJ Hughes" wrote:

I've just started seeing this too - clearcontents hangs Excel, but only with large ranges. Did removing the security update work? Restoring the system to a previous date did nothing.


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com



All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com