HELP: Excel 2010 macro won't function in Excel 2016 :(

[salvadope]

Hi,

An Excel macro developed in the 2010 build of Excel will not work in the 2016 version. Is this a frequent issue? I get this error message:

Run-time error '9':

Subscript out of range

I can see two ways of fixing this:

1) Recoding the macro so that it works in 2016;

or 2) To open Excel 2016 in some sort of backwards compatibility mode so that the 2010 file works.

I'll attach the file in question here Uploadfiles.io - MapaRitmoRedkenS.xlsm. It's written in Portuguese and the relevant macro is the one present in the sheet "MapaRitmo"

Thanks for your help!

 

[Special-K99]

This error also occurs when a specified worksheet does not exist.
Check all the worksheets you are using actually exist, in particular the fil on the W: drive which of course we can't open

 

[Peter_SSs]

Welcome to the MrExcel board!

My guess is that as well as a new Excel version you also have a new Windows version, or have changed the settings in Windows Explorer and that the error is in a line like this

Workbooks("MapaRitmoRedken.xlsm").Activate

If, in Windows Explorer you now have the setting to not show the file name extensions, that line will error with the error message you report. Have a look in Windows Explorer 'View' tab and 'File Name Extensions' checkbox. If it is not checked, then check it and try your macro again.