The most common error in arrays - Simple Excel VBA

preview_player
Показать описание
Hello Ladies and Gentlemen! In this video I want to present You the most common error associated with array creation which is Run-time error ‘9’: Subscript out of range.

Please like and subscribe my channel, it means a lot for me :)

Рекомендации по теме
Комментарии
Автор

Hello Your video is fantastic. I was looping into an array and I was getting that error message : Subscript out of range. I spent many days trying to resolve it. You are right. One of my array had only one dimension but Excel was waiting for 2 dimensions and I was getting the error message. I added your code: arr_Act = and it resolved my problem! Thanks again !

michelpilon