Microsoft Excel 2010 comes with the latest version of Visual Basic for Applications, or VBA, which is a programming language designed to interface easily with Microsoft Office products. VBA allows you ...

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.