LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default VBA Code runtime error only after opening Locals window

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
runtime error code 1004 Karen Excel Worksheet Functions 1 May 13th 10 12:21 AM
Macro runtime 1004 error on opening worksheet Shaggyjh Excel Discussion (Misc queries) 5 May 6th 09 12:37 PM
RunTime Error 424 in a USERFORM's code JimP Excel Programming 0 November 26th 04 05:27 AM
Locals Window - Extracting Contents Alan Excel Programming 4 November 16th 04 03:06 PM
runtime error 1004 when opening excel file via VBA in a browser Ken Hunter Excel Programming 2 July 31st 03 03:33 PM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"