Category: vba

Many times, we need to add a new sheet to a workbook. You can use Excel VBA or the keyboard shortcut to add…

Visual Basic for Applications (VBA) is a great tool for the automatization of our work. It can also be used to manipulate any…

Sometimes you may want to write a macro that identifies the active row in your spreadsheet. This tutorial shows you how to get…

Sometimes you may want to convert Integer and Long values to strings. This is so that you can use string manipulation functions on…

With VBA, we can manipulate our data in virtually any way imaginable. It can be useful for both creating and deleting work. In…

As you are probably aware, Visual Basic for Applications (VBA) is a very powerful and useful tool. Its most convenient feature is the…

Sometimes we may want to check for the format of a cell in Excel VBA. This tutorial shows you how to get the…

All Office programs (Excel, PowerPoint, Word, etc.) have a similar way of functioning in the background. They can all be controlled with VBA…

Sometimes you get a dataset that has numbers stored as text. This means you cannot work with the values as you would with…

Sometimes when you receive an Excel workbook that contains VBA code you may want to remove the code to make the workbook macro-free….