Results 1 to 13 of 13

Excel always crashes at the very same point of the code

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    10

    Excel always crashes at the very same point of the code

    Hi community

    I've still got some serious trouble with a Excel-document I'm working on. It's a file supposed to compare offers from various building firms. Thus I wrote a button-released code to sort the offers from cheapest to most expensive. I think the code should be all right by now, but every time I run it, excel crashes (with "runtime error 9: subscript out of range", when I press "debug", the program shuts down). By step by step running the code, I figured that it always crashes on line 14, no matter whats wirtten on this line. This made me think it might be a software-problem. But I tried running it on an other computer and had the same Problems. I also tried copy-paste into another file, but it didn't solve my problems neither
    As attachment you will find the file. I'm sorry it's in German. The row to be sorted on is row 43.
    I'm using windows 7 and ms-office 2010 professional plus. in case that helps ;-)

    Thanks a lot for your help!
    Greets
    Freakygreeneyes
    Attached Files Attached Files
    Last edited by freakygreeneyes; 07-26-2013 at 10:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Crashes when adding code to workbook via VBA
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-24-2009, 01:10 PM
  2. Excel crashes when I create code through a routine
    By Caligula in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2007, 03:55 PM
  3. My code crashes excel
    By ben_sumner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2006, 03:20 AM
  4. Excel crashes when code runs, Please help.
    By Potoroo in forum Excel General
    Replies: 2
    Last Post: 09-12-2006, 08:39 PM
  5. [SOLVED] VBA WinInet Code Crashes Excel
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2006, 12:55 AM

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