+ Reply to Thread
Results 1 to 2 of 2

excel 2016 stops running(crashes) after running VBA that was working fine on previous vers

  1. #1
    Registered User
    Join Date
    09-14-2013
    Location
    hamilton, ontario
    MS-Off Ver
    Office 365
    Posts
    7

    excel 2016 stops running(crashes) after running VBA that was working fine on previous vers

    Hi out there!

    My vba code (below) has worked with no issues in all windows versions and office versions until Excel 2016. The code does what is supposed to do but now with Excel 2016 excel stops running (windows is checking for a solution...) and then crashes and reopens excel. There are no error messages. Does my code need an edit to address this in 2016? Thank you in advance

    My Code is in 'This Workbook' with no modules:
    Please Login or Register  to view this content.
    Last edited by lauriejerome; 07-08-2017 at 02:01 PM.

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: excel 2016 stops running(crashes) after running VBA that was working fine on previous

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Also, could you attach an excel file where you get this error so we can replicate the error here and check.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

+ 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. [SOLVED] After running this macro a dynamic range stops working. How to fix?
    By 80Wil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-30-2017, 07:54 PM
  2. VBA code not working on Mac machine running Excel 2011 (works fine on Windows!)
    By LochWulf in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2016, 11:25 PM
  3. Excel Forum was Down, Running fine NOW!
    By EFmanagement in forum Suggestions for Improvement
    Replies: 3
    Last Post: 05-28-2016, 03:43 AM
  4. ESC key stops working in Excel: Is Photoshop running?
    By 6StringJazzer in forum Tips and Tutorials
    Replies: 0
    Last Post: 07-28-2015, 03:44 PM
  5. [SOLVED] Command button stops working after running other macros
    By Bearz in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-20-2015, 06:37 PM
  6. [SOLVED] 2010 Excel stops working when running macros
    By Yamaha Rider in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2013, 02:40 PM
  7. Replies: 0
    Last Post: 12-18-2008, 05:06 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