+ Reply to Thread
Results 1 to 3 of 3

"Microsoft Excel has stopped working" just on using IsMissing(copy from non init array) !

  1. #1
    Registered User
    Join Date
    03-22-2009
    Location
    Antwerp
    MS-Off Ver
    Excel 2002 SP2
    Posts
    45

    Exclamation "Microsoft Excel has stopped working" just on using IsMissing(copy from non init array) !

    I nailed the bug in MS-Excel 2010 down to this simple code:

    Don't know if it is only in my Excel 2010 - 64bit, Windows 7 (win7-x64)

    Please Login or Register  to view this content.
    It is solved when adding () in the Dim ... copyVar() As Variant. But for some reason, hard to explain here, I want to use that copyVar also to hold non array's, so I don't want to use ()
    Nevertheless "IsMissing" shouldn't raise a fatal-error, right!?
    Last edited by onidarbe; 06-10-2013 at 06:36 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: "Microsoft Excel has stopped working" just on using IsMissing(copy from non init array

    Do you want this thread marked as solved - it currently is. If not, click thread tools above, and mark it unsolved
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-22-2009
    Location
    Antwerp
    MS-Off Ver
    Excel 2002 SP2
    Posts
    45

    Re: "Microsoft Excel has stopped working" just on using IsMissing(copy from non init array

    I know ;-) I though I solved it and also wrote that I did found a solution. Well, not really solved the bug, but found a way not to have it.
    But here's a question that I can't seem to solve:

    I want a routine that actual clones a variable what ever it is, String, Object or even that un-allocated array. But as soon as one uses IsMissing() on that cloned un-allocated array the fatal error "Microsoft Excel has stopped working" closes Excel!

    Please Login or Register  to view this content.
    thanks
    Last edited by onidarbe; 06-10-2013 at 06:45 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1