An Introduction to Automation Every user of a computer has some mundane task to do every day. For example, you may have to execute something at a particular time on your machine or check the value of some stock or commodity every minute if you
Today I’ll show you how to resolve the error “End If without block If” in VBA. But first, you have to understand the “If” statement in order to fix the issue. The IF statement and its various forms The If statement is a conditional clause
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