Debugging VBA built on Excel2013 not working on v2016

**Nyaralist** · 10-26-2020, 03:58 PM

Hi!
I am New here

We updated recently to excel 2016 and when trying to run the onld VBAs we get errors in the code we did not get before the update... maybe there are changes we re not aware...

Also, the code was developed by and external and have no clue what can be going wrong....

We have the following code:

HTML Code:

etc...

But I have been getting errors on these last 2 lines: Run time error '9' "Subscript out of range"

I am moving teams and must handover this soon, so was trying to test it to show it to my successor, but I cannot figure out what can be wrong here since I did not do the code, only guided the development of it, please your help!

Thank you!!

I have also posted this under these other forums:
ozgrid
vbaexpress
mrexcel

I tried several times to add the URLs but I get the message that I am "not allowed to post any kinds of links, images or videos until you post a few times."

The issue was resolved, the problem with this is that it required that the workbook was opened in the same excel instance

**6StringJazzer** · 10-26-2020, 08:26 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)