All posts by Lakshmi Ramakrishnan

What are SendKeys in VBA?

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

VBA Naming Conventions: Best Practices

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

What is a VBA Dictionary?

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

How Do You UNSORT Data in Excel?

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