Video tutorial: Arrays as best Excel table alternative!

Arrays are awesome. This is one of the main things You should learn working with Excel VBA. In case of data, I think I can safely say, that arrays are the best alternative for tables in VBA. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!

Run-time error ‘9’: Subscript out of range – array

In this post I want to present You the most common error associated with array creation which is Run-time error ‘9’: Subscript out of range.

Run-time error '9': Subscript out of range - arrays
Continue reading “Run-time error ‘9’: Subscript out of range – array”

How to declare array in Excel VBA?

I don’t want to make a duplicate of official Microsoft Office website, because it is not the case and I see no point in it. You are here, because You were there. Now You are looking for more details or examples how to declare array to deal with common, daily tasks.

Continue reading “How to declare array in Excel VBA?”

Array vs table – store color property speed comparison

All in all, array is awesome to operate on big data. It is much faster vs standard Excel table. But how they gonna behave in the situation presented like in https://simpleexcelvba.com/can-arrays-store-cell-properties-like-font-colors-or-fill-colors/ where I’m using 3rd dimension to store color property in array?

Continue reading “Array vs table – store color property speed comparison”