Get the Current Row Using VBA
Sometimes you may want to write a macro that identifies the active row in your spreadsheet. This tutorial shows you how to get…
Category: vba
Convert Integer to String Using VBA
Sometimes you may want to convert Integer and Long values to strings. This is so that you can use string manipulation functions on…
Set Range to Empty in VBA
With VBA, we can manipulate our data in virtually any way imaginable. It can be useful for both creating and deleting work. In…
Close Workbook in VBA Without Saving
As you are probably aware, Visual Basic for Applications (VBA) is a very powerful and useful tool. Its most convenient feature is the…
Get the Cell Format in VBA
Sometimes we may want to check for the format of a cell in Excel VBA. This tutorial shows you how to get the…
Insert Header in Excel Based on Cell Value
All Office programs (Excel, PowerPoint, Word, etc.) have a similar way of functioning in the background. They can all be controlled with VBA…
Convert Range from Text to Number in VBA
Sometimes you get a dataset that has numbers stored as text. This means you cannot work with the values as you would with…
Remove VBA from Excel
Sometimes when you receive an Excel workbook that contains VBA code you may want to remove the code to make the workbook macro-free….
Create and Write to a Text File Using VBA
Sometimes we may want to transfer the data we have in our Excel worksheets to a text file for archiving or other purposes….
Refresh a Userform in VBA
There are virtually limitless possibilities when working with Visual Basic for Applications (VBA). When you start dealing with it, the first thing you…