+ Reply to Thread
Results 1 to 2 of 2

Excel Crashing at every turn - F5, F8, Save while working on date based routine

  1. #1
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Excel Crashing at every turn - F5, F8, Save while working on date based routine

    I had the devils own time writing a solution to this post if you could please take a look and advise?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Excel Crashing at every turn - F5, F8, Save while working on date based routine

    Hi Orrin,
    I tried your code in the OP’s uploaded workbook,…. Like this:


    I copied the OP’s “BEFORE” Worksheet and named that copied worksheet “OrinAfter”
    I put your code from post #10 ( https://www.excelforum.com/excel-pro...ml#post4679024 ) in a normal code module.
    Then I ran your code with Worksheet “OrinAfter” active.

    The code ran with no problems. It appears to reproduce the OP’s “AFTER” worksheet almost perfectly, ( just the last digits is a bit different on some numbers , but might be some number formatting at my end )

    Enclosed the file after running the code.

    Alan

    (I am using XL 2007 )
    Attached Files Attached Files
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel crashing when trying to save spreadsheet with macro
    By Rachel007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2015, 12:54 PM
  2. Save As macro keeps crashing excel program
    By GmcdAU in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2015, 10:57 PM
  3. [SOLVED] Excel Crashing with VBA that was working
    By CWicklund in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2013, 03:51 PM
  4. can I save if excel is currently crashing
    By dmalloy8 in forum Excel General
    Replies: 0
    Last Post: 08-22-2010, 09:13 PM
  5. Excel crashing when working with large files
    By theradpotato in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2010, 01:40 PM
  6. Excel spreadsheet keeps crashing on save
    By Scotts Neil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2007, 07:44 AM
  7. Excel 2003 crashing - turn off autorecover?
    By Ken Valenti in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2005, 08:06 PM

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