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


Check VBE/tools/options
Tab:General
Break in Class module must be activated.

I assume an error is thrown in one of the property get procedures
that you fail to pick up.

Cant analyse without seeing the code. Just went into 1 of my own multi
hierarchy classes and had no problems. expanding and collapsing to my
heart's content :)

you can mail me the book and i'll have a look.
(pls zip and mention excel version..)

my email is my signature below.
just add @ and . around chello (or rot13 the sender address)

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


keeena wrote in
groups.com

One more tidbit of info...

If I place a statement right before the end of the routine (e.g.
debug.print "Junk"), this statement will be executed prior to the
Error 91. So the error is thrown after all the code has run.

I explicitly dereference all objects prior to this debug.print
statement. So the error is being thrown when VBA is performing its
own cleanup. How could I debug this further?

TIA,
-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 02:01 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"