In any programming language it is quite natural for you to use several variables and objects to develop code. Throughout this process, you might get confused referencing them for the first time or reusing them for the second time. For example, you might create a
A dictionary is an object in VBA (similar to a collection) that stores data like an array. It can be used to store data of any type except an array. A VBA dictionary has two parts: Key Value …where key is simply a reference to the
The sorting feature of Excel is very useful to organize and put data into a structured format. But many times, we think of a better way to do it — only after we complete the data sorting! So somehow we have to revert the sorting
Are you sitting there staring at this error on your VBA screen and getting frustrated? No worries, we shall fix it. But before deep diving into the root cause and solution to fix this error, let’s understand the correct procedure for using an object in