VBA Errors in Excel 2016

[automationamateur]

I was recently upgraded from Excel 2013 (32 Bit) to Excel 2016 (64 Bit) on windows 7 enterprise OS. Macros I have been using for years have all the sudden stopped working and erroring out on the oddest code. Any help is greatly appreciated, I'm not sure what I am missing. Thanks!

This existing code that is extremely simple and has worked for years now creates error, "Run-time error '-2147417848 (80010108)':Method 'Delete' of object' _Worksheet' failed"

Sheets("Sample Sheet").Delete

When I run macro recorder to accomplish the same task Excel 2016 now creates this:

Sheets("Sample Sheet").Select
ActiveWindow.SelectedSheets.Delete

 

[automationamateur]

Copy the sheet name from your errant code and paste it to a cell (let's say A1 for example). Then copy the sheet tab name from a sheet that can't be deleted from the 2013 code and paste it to another cell (say B1 for this example). Now in C1 enter: =EXACT(A1,B1)

What do you get? If FALSE, then in D1 enter: =LEN(A1) and copy it to E1. Does D1 differ from E1?

Sheet name is not the problem, I know its not because it works in 2013, if there was a mismatch it wouldn't work in excel 2013 either.

 

[JoeMo]

Sheet name is not the problem, I know its not because it works in 2013, if there was a mismatch it wouldn't work in excel 2013 either.

Can you invest a couple of minutes and try what I asked? That would confirm if sheet name is the problem.

 

[automationamateur]

I did, it is true, it is the exact same. Let me add this for clarification: the only difference is excel 2013 vs 2016 (not a single other thing has changed). For example, my coworker still has 2013, i give him my workbook and the macro works fine on his machine as it has for years on both his and my machine. I use the exact same workbook/macro on my machine with excel 2016 and it fails.

 

[JoeMo]

I did, it is true, it is the exact same. Let me add this for clarification: the only difference is excel 2013 vs 2016 (not a single other thing has changed). For example, my coworker still has 2013, i give him my workbook and the macro works fine on his machine as it has for years on both his and my machine. I use the exact same workbook/macro on my machine with excel 2016 and it fails.

Very strange - think I'll stick with Excel 2010 until a new version arrives.