Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an odd problem and was wondering if anyone had some insight to
my issue. I have some code which appears to run perfectly fine under normal conditions. I can run multiple iterations w/ no issues what so ever. However, if I... - pause code execution - view Locals - expand the Locals tree to view a variable that is an instance of my own class - then attempt to resume execution ....the code will fail with Error 91 (Object variable or With block variable not set) Furthermore, if I click on Debug in the error window, no failure point is highlighted in the code (side note - I do have the debug option to break in Class Modules). Code remains in the break state. My code is somewhat complex so I'll hold off on posting the code for now. What I initially want to know is if there is a common explaination for this type of failure. I'm hoping that will point me in the right direction so I can find the problem. One more point - I am using the published hack to create my own collection classes (actually, I have a heirarchy of collection classes). The code fails only when I expand the expression which is an instance of my collection class. I am using Excel 2003 SP2. Thanks, -K |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
runtime error code 1004 | Excel Worksheet Functions | |||
Macro runtime 1004 error on opening worksheet | Excel Discussion (Misc queries) | |||
RunTime Error 424 in a USERFORM's code | Excel Programming | |||
Locals Window - Extracting Contents | Excel Programming | |||
runtime error 1004 when opening excel file via VBA in a browser | Excel Programming |