Summing Excel cells by color: an "easy" way and a "hard" way.

Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.

Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.

Use VBA to check for nearly identical data in your Excel worksheet.

In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...

Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...

Adding a Visual Basic structure to your Excel file for validating data.

I wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s...

If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...

How to add line numbers to VBA

The other day I had a client ask me to create a reminder in an Excel document that would pop up several times a day. It had to run at...

Recording macros in Excel is an easy way to automate repetitive tasks. Maybe you receive a new file every month with your sales figures...

If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little...