Tag Archives: VBA

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

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

All About Autofilter in VBA

We all are very well aware of the efficiency of MS Excel. However, to further enhance its efficiency, VBA macros come in handy. Without using macros, you can easily filter out information in a dataset, based on criteria, using the ‘Filter’ feature within the ‘Data’

How to Fix Compile Error: Expected: End of Statement

Introduction Every programming language has its own grammar and vocabulary — technically known as syntax. Having a mastery of any language implies that you have a sound knowledge of its syntax. As a beginner in VBA, you might be confronted with frustrating errors like the

Cross Products with Excel and VBA

Microsoft Excel does not have the built-in worksheet functions to calculate the cross product of two vectors. Therefore, some techniques are required to do the calculation — either by setting up your own formula in a worksheet or by creating a custom VBA function. The

How to Use NumberFormat in VBA

Description FormatNumber is a property of the Range object of Excel. The Range object can be considered as a cell or a group of cells — be that a single cell, a column in an Excel table, or the UsedRange of an Excel sheet. The

VBA vs Python: Key Differences Plus a Dose of History

Introduction When beginning your coding career, you will certainly ask yourself questions like, “What exactly is a programming language?”, “Which programming language should I learn”, “What is the difference between language A and language B”, etc. The answer to these questions and many others can

No Thumbnail

Visual Basic vs. Visual Basic for Applications

Over the years, I have been asked this question many times: What is the difference between VB and VBA? I tried to answer in many ways, but, ultimately, I found this answer the easiest one for most people to understand quickly: With VB, you make