ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel XP - VBA crashing because of Exception handling (https://www.excelbanter.com/excel-programming/278091-excel-xp-vba-crashing-because-exception-handling.html)

pcw[_2_]

Excel XP - VBA crashing because of Exception handling
 
Context: I developed in Excel XP using extensive VBA code

Problem: The code appears to cause Excel to sometimes
crash. Not all the time.
In Excel 97, this doesn't happen at all.

Error Message: The following is the error message I get
-- "The instruction at "0x00f00179" referenced
memory at "0xffffffff." The memory could not
be "read". An exception "Unhandled Win 32
Exception" has occurred in EXCEL.EXE.

Debug: When I debug in Assembly language, I get
"Unhandled exception at 0x00f00179 in Excel.EXE:
0xC0000005: Access violation reading location
0xffffffff
Assembly: 00F00177 add byte ptr(eax), bl
00F00179 pop ds
00F0017A lock add byte ptr[eax+30h], ah


Would anyone know what type of VBA code would cause this
as I desperately need to fix this problem?


All times are GMT +1. The time now is 05:42 PM.

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