+ Reply to Thread
Results 1 to 4 of 4

Macro built in Excel 2011 crashes workbook in Excel 2016

  1. #1
    Registered User
    Join Date
    04-23-2018
    Location
    United States
    MS-Off Ver
    2011
    Posts
    2

    Macro built in Excel 2011 crashes workbook in Excel 2016

    Hello,

    I have built a workbook for a client that consists of simple formulas and a very basic Macro. I am using Excel 2011 and the Macro runs perfectly with no issues. However, when my client runs the Macro on his computer (he is using Excel 2016), the workbook crashes. We are both using Mac laptops. Here is the VBA code:

    Sub Insert2()
    '
    ' Insert2 Macro
    '

    '
    Range("A3:O3").Select
    Selection.Copy
    Range("A12:O12").Select
    Selection.Insert Shift:=xlDown
    Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
    End Sub

    Any thoughts would be greatly appreciated since this problem has completely baffled me. The code is simple and causes no issues when I run it. Thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Macro built in Excel 2011 crashes workbook in Excel 2016

    Works fine for me in Excel 2010 (on a PC). Could be shorter.

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-23-2018
    Location
    United States
    MS-Off Ver
    2011
    Posts
    2

    Re: Macro built in Excel 2011 crashes workbook in Excel 2016

    Thanks for the shortened code. Works great on my computer. Any thoughts, however, why it is still crashing on my clients computer? Should he reinstall office? It makes no sense that it works on every other OS, Excel version, etc.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Macro built in Excel 2011 crashes workbook in Excel 2016

    There is nothing complex about that code, or anything to cause Excel to crash.

    When does it crash? How does it crash? Is there a message? Is a line of code highlighted? Is the workbook protected? Are any sheets protected? Are any cells locked?

    Can you step through the code and see which line causes the failure?

    If you remove the code, does the workbook function as expected?

+ 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] Unalterable Excel 2016 spreadsheet always crashes
    By Zarathrustra in forum Excel General
    Replies: 7
    Last Post: 02-13-2018, 07:13 AM
  2. [SOLVED] Excel MAC 2011/2016 Updating master workbook from second workbook not working
    By shirleyxls in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 05-25-2017, 10:36 AM
  3. Multiple crashes of Excel for Mac 2011 with large data sets
    By mskumar1512 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 07-29-2014, 08:40 PM
  4. Excel (2011) Crashes when trying to run an add-in .xla
    By fergu260 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2013, 11:11 PM
  5. Excel 2011 Macro Crashes after Saving File
    By tpeters74 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2013, 03:41 AM
  6. Replies: 1
    Last Post: 02-24-2013, 06:28 PM
  7. Code works in Windows excel 2003 and 2010 but crashes in Mac excel 2011
    By kiweed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 08:46 PM

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