Subscript out of range vba error 9 excel, but it works on other laptops

[AntuanKriaki]

Hello Everyone, this is my first post in this community, I have this very weird problem regarding on the Macros files with excel, basically, there is a file using Macros working on my laptop, but I can't make it work on other laptops, those other laptops have the same office version, and even the same systems and config on each one of them, when I try to add or edit anything it gives this error: (subscript out of range, error 9), I will include a photo who the VBA looks in each laptop where this file doesn't work, if you have anything to add please let me know, because I already searched for this too many times now,

Thanks,

 

[Special-K99]

I recall from years ago that "Subscript out of range" error can also be displayed when a specified sheet does not exist.

 

[AntuanKriaki]

I recall from years ago that "Subscript out of range" error can also be displayed when a specified sheet does not exist.

but as I mentioned, this file works on other computer with the same config and same office version

 

[Special-K99]

Same problem here.

Subscript out of range error only on certain computers

Hello, I am running across an issue where I receive the Subscript out of Range Error 9 when trying to execute a macro. Using a identical file, it only happens on half of my coworker's computers, but works just fine on others. Have any of you come across this type of scenario? Could this be an...

www.mrexcel.com

Again opening files

https://stackoverflow.com/questions/26913112/subscript-out-of-range-on-computers-other-than-mine

Same problem, with a solution

Macro Works On One Computer But Not Another: Subscript Out Of Range ` - OzGrid Free Excel/VBA Help Forum

Hi Folks, I've written a simple test macro which simply sets the current workbook's used range to a range variable. No problem here. I've done it many times. Now when I close the workbook, open it on my boss's machine and try to run the macro I get an…

forum.ozgrid.com

 

[RoryA]

Which line is actually causing the error?

 

[Peter_SSs]

Just one other comment. The green test below will always be true so the yellow lines will always be executed.

I suspect you really meant 'And' where you have 'Or' in the green line

 

[AntuanKriaki]

Just one other comment. The green test below will always be true so the yellow lines will always be executed.

View attachment 105553

I suspect you really meant 'And' where you have 'Or' in the green line

But why it shows question marks on the sheet name, and on a working laptop it shows the right name in other language?

 

[Peter_SSs]

But why it shows question marks on the sheet name, and on a working laptop it shows the right name in other language?

I don't know, but presumably because of the different language/regional settings on each machine.

Your question though is unrelated to my comment about the vba code.

 

[AntuanKriaki]

I understand that, but your comment is also nothing to do with the problem that its not working on other laptops, when I press Debug, it shows that all the code is wrong, because it doesn't recognize the language, it basically shows questions marks and so on, and that only laptop that it works, the language shows ok

 

[Peter_SSs]

but your comment is also nothing to do with the problem that its not working on other laptops,

True. My point was simply about some unusual logic in the code that I thought you might be interested in knowing about.

You did say ..

if you have anything to add please let me know,

.. so I let you know.