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

The Invalid Use of Nulls error message is common in VBA code when using Microsoft Access. Find out how to write code to deal with it.

VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?

Here are 3 good reasons to use named ranges in Excel.

Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.

Using VBA code to check for #N/A in an Excel cell. The CVErr function allows you to check for several of the "#" errors in Excel.

Create an audible alarm in Excel that beeps when a timer expires.

A while back, I wrote about creating a timer in Excel. In that post, I went into detail about my failed attempts to create one, and how I...

The Overflow error occurs in Visual Basic when you exceed the limits of a variable's data type.

VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.

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...

Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...

Adding a Watermark to an Excel document only when printing

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...