From time-to-time, you may need to use Visual Basic for Applications for purposes of working with fonts. For example, you may want to: Apply bold or italic style. Specify the font color or size. Set the characteristics of the text underline. If you're in a situation where you want to modify a font attribute, this VBA Tutorial should help you. My purpose with … [Read more...]

Whenever you work with Excel, either manually or using Visual Basic for Applications, you probably spend a substantial amount of time dealing with cells and cell ranges within a worksheet. Knowing how to appropriately navigate an Excel worksheet using VBA is one of the most important skills you can learn. This is because several of the activities you carry out using Visual … [Read more...]

One of the most basic and common operations in Excel is creating a new workbook. You've probably created a countless number of new workbooks yourself. If you're automating some of your Excel work by using Visual Basic for Applications, the ability to create new workbooks can be of immense help. You may want, for example, do any of the following: Create a new workbook … [Read more...]

You're probably aware that the process of cleaning up data can be annoying and time consuming. At the same time, it's important to ensure the accuracy of the data you're using for your analysis. Excel VBA macros can help you automate some data-cleanup activities. At the same time, if you set up your macros properly, they can reduce the risk of mistakes during the … [Read more...]