I’d like to invite You to my second YouTube tutorial video, which is about the most common error in arrays. Watch it here or go to my channel.
Enjoy the video, leave a like and subscribe to my channel!
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.Continue reading “Run-time error ‘9’: Subscript out of range – array”
There are variables assigned to array. Will variables value change, if array values change?Continue reading “Change variables value in array”
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?”
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”
I am big fan of arrays. Since I found out about arrays I have been trying to use them everywhere! Or maybe just there where it is possible.
I recently wrote about them, if You missed it I highly recommend reading my post https://simpleexcelvba.com/arrays-one-of-the-best-things-you-can-learn-in-excel-vba/ We all know that arrays can store values, for example 2 dimensional array can hold a Excel table values. But can arrays store cell color property?