Video tutorial: Store color property – array vs table speed comparison

Is it possible to store for example color property in VBA array? If yes, which approach is faster – array or standard Excel table?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!

Video tutorial: Progress bar – watch your macro performance

Starting to code in VBA I always wanted to see that loading rectangle as a progress bar to watch the working macro. Not only for fancy issue, but mainly to know in which point of macro I am. In this video I’ll show You simple example of progress bar. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!

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!