Tag Archives: VBA For Excel

Use Any Formula: Worksheetfunction in VBA

Formulas in EXCEL Microsoft Excel offers several built-in functions that can be used as formulas in Excel worksheets. It displays the categories of functions available in the Insert Function window, as seen in the image below: Usage of Formula in an Excel Sheet Just like

Inserting Rows in VBA: 6 Methods to Try

Rows are the horizontal layers of data — whether empty or not — in any table. You can think of a worksheet in MS Excel as a table. Likewise in Word, tables can be inserted and used. Rows are essential part in any table used

Using the VBA Format Function

Short introduction to strings A string is a sequence or group of characters of any length that may or may not have a semantic meaning in language. It can consist of several characters like numbers, letters in both lowercase and uppercase, punctuation, and symbols. Examples

Funcres.xlam and Analysis Toolpak in Excel/VBA

An introduction to funcres.xlam Funcres.xlam is an add-in available within Microsoft Excel. This is an “Analysis Toolpak” and includes 19 different features and various statistical functions to help you work with the data available in your Excel worksheets. In order to use this add-in, which

How to Use Application.Calculation in VBA

The benefits of using Excel for calculation We are well aware that in today’s world, a machine’s brain works orders of magnitude faster than a human’s brain. By this, I mean that when there is a requirement to calculate some numbers mathematically, we have quickly

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’

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